DBA Data[Home] [Help]

APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_CLMREQ_DIST_DETAILS_V

Line 1034: PO_CLMREQ_DIST_DETAILS_V DV

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
1035: WHERE REQ_DIST_GT.INDEX_NUM1 = NEW_DIST_GT.REQ_DISTRIBUTION_ID
1036: AND REQ_DIST_GT.INDEX_CHAR1 = 'LINKREQDIST_REQDISTID'
1037: AND DV.distribution_id = NEW_DIST_GT.REQ_DISTRIBUTION_ID
1038: GROUP BY NEW_DIST_GT.REQ_DISTRIBUTION_ID;