DBA Data[Home] [Help]

APPS.PO_CONTRACTS_S dependencies on PO_LINE_LOCATIONS_GT

Line 115: po_line_locations_gt pll, --

111: AND poh2.currency_code <> x_currency_code
112: UNION ALL
113: SELECT 'Exists'
114: FROM po_lines_gt pol, --
115: po_line_locations_gt pll, --
116: po_headers_gt potoapp --
117: WHERE pol.contract_id = X_contract_id --
118: AND pol.po_line_id = pll.po_line_id
119: AND pol.po_header_id = potoapp.po_header_id

Line 196: po_line_locations_gt pll, --

192: )
193: )
194: INTO X_current_amount
195: FROM po_lines_gt pol, --
196: po_line_locations_gt pll, --
197: po_headers_gt potoapp --
198: WHERE pol.contract_id = X_contract_id --
199: AND pol.po_line_id = pll.po_line_id
200: AND pol.po_header_id = potoapp.po_header_id