DBA Data[Home] [Help]

APPS.PO_CONTRACTS_S dependencies on PO_LINE_LOCATIONS_GT

Line 122: po_line_locations_gt pll, --

118: AND poh2.currency_code <> x_currency_code
119: UNION ALL
120: SELECT 'Exists'
121: FROM po_lines_gt pol, --
122: po_line_locations_gt pll, --
123: po_headers_gt potoapp --
124: WHERE pol.contract_id = X_contract_id --
125: AND pol.po_line_id = pll.po_line_id
126: AND pol.po_header_id = potoapp.po_header_id

Line 204: po_line_locations_gt pll, --

200: )
201: )
202: INTO X_current_amount
203: FROM po_lines_gt pol, --
204: po_line_locations_gt pll, --
205: po_headers_gt potoapp --
206: WHERE pol.contract_id = X_contract_id --
207: AND pol.po_line_id = pll.po_line_id
208: AND pol.po_header_id = potoapp.po_header_id