DBA Data[Home] [Help]

APPS.PO_CONTRACTS_S dependencies on PO_LINE_LOCATIONS_ALL

Line 110: po_line_locations_all pll,

106: from dual
107: where exists (
108: SELECT 'Exists'
109: FROM po_lines_all pol,
110: po_line_locations_all pll,
111: po_headers_all poh2
112: WHERE pol.contract_id = X_contract_id --
113: AND pol.po_line_id = pll.po_line_id
114: AND poh2.po_header_id = pol.po_header_id

Line 162: po_line_locations_all pll,

158: )
159: )
160: INTO X_purchased_amount
161: FROM po_lines_all pol,
162: po_line_locations_all pll,
163: po_headers_all poh2
164: WHERE pol.contract_id = X_contract_id --
165: AND pol.po_line_id = pll.po_line_id
166: AND poh2.po_header_id = pol.po_header_id