Procurement - EBS (MOSC)

MOSC Banner

sub query for total release amount of BPA

in Procurement - EBS (MOSC) 2 commentsAnswered

Hello,

looking for a sub query for total release amount of bpa.

in this query, i want to add it

SELECT DISTINCT hru.NAME

phv.PO_HEADER_ID

phv.SEGMENT1

phv.TYPE_LOOKUP_CODE

phv.CREATION_DATE

phv.COMMENTS

phv.END_DATE

phv.AUTHORIZATION_STATUS

phv.APPROVED_DATE

phv.CURRENCY_CODE

phv.BLANKET_TOTAL_AMOUNT

phv.AGENT_NAME

phv.VENDOR_NAME

phv.VENDOR_SITE_CODE

phv.VENDOR_CONTACT

phv.SHIP_TO_LOCATION

phv.BILL_TO_LOCATION

phv.PAYMENT_TERMS

phv.ORG_ID

status

plv.LINE_NUM

plv.ITEM_NUMBER

plv.ITEM_DESCRIPTION

plv.QUANTITY

plv.UNIT_PRICE

(select sum(quantity) from PO_LINE_LOCATIONS_RELEASE_V where po_line_id= plv.po_line_id) qty_released

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Procurement Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center