DBA Data[Home] [Help]

APPS.PO_CREATE_ASBN_INVOICE dependencies on PO_LINE_LOCATIONS

Line 119: po_line_locations pll,

115: DECODE(pll.taxable_flag, 'Y', pll.tax_code_id, NULL) tax_code_id,
116: rsl.tax_amount,
117: pll.match_option
118: from
119: po_line_locations pll,
120: po_lines pol,
121: rcv_shipment_lines rsl
122: where
123: rsl.shipment_header_id = p_shipment_header_id and

Line 147: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

143: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
144: l_error_msg VARCHAR2(2000);
145: /* */
146:
147: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
148: l_tax_classification_code VARCHAR2(30);
149: BEGIN
150:
151: OPEN c_asbn_header;

Line 199: 'PO_LINE_LOCATIONS', -- table_name

195: X_batch_id, -- batch_id
196: p_shipment_header_id,
197: NULL, -- line_id
198: 'PO_INV_CR_INVALID_MATCH_OPTION',
199: 'PO_LINE_LOCATIONS', -- table_name
200: 'MATCH_OPTION', -- column_name
201: null,
202: null, null, null, null, null,
203: null,