DBA Data[Home] [Help]

APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_REQS_INQ_SV

Line 1030: MIN(PO_REQS_INQ_SV.GET_REQ_AMOUNT ('J' , REQ_DISTRIBUTION_ID)) REQ_DIST_AMOUNT,

1026: SELECT REQ_DISTRIBUTION_ID,
1027: SUM(NEW_DIST_GT.AMOUNT_ORDERED) TOTAL_AMOUNT_ORDERED,
1028: SUM(NEW_DIST_GT.FUNDED_VALUE) TOTAL_FUNDED_VALUE,
1029: MIN(REQ_DIST_GT.NUM1) FUNDS_TO_USE,
1030: MIN(PO_REQS_INQ_SV.GET_REQ_AMOUNT ('J' , REQ_DISTRIBUTION_ID)) REQ_DIST_AMOUNT,
1031: Min(DV.FUNDS_REMAINING) FUNDS_REMAINING
1032: FROM PO_SESSION_GT REQ_DIST_GT,
1033: PO_DISTRIBUTIONS_GT NEW_DIST_GT,
1034: PO_CLMREQ_DIST_DETAILS_V DV