DBA Data[Home] [Help]

APPS.PO_CREATE_ASBN_INVOICE dependencies on PO_LINE_LOCATIONS

Line 106: po_line_locations pll,

102: DECODE(pll.taxable_flag, 'Y', pll.tax_code_id, NULL) tax_code_id,
103: rsl.tax_amount,
104: pll.match_option
105: from
106: po_line_locations pll,
107: po_lines pol,
108: rcv_shipment_lines rsl
109: where
110: rsl.shipment_header_id = p_shipment_header_id and

Line 134: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

130: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
131: l_error_msg VARCHAR2(2000);
132: /* */
133:
134: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
135: l_tax_classification_code VARCHAR2(30);
136: BEGIN
137:
138: OPEN c_asbn_header;

Line 187: 'PO_LINE_LOCATIONS', -- table_name

183: X_batch_id, -- batch_id
184: p_shipment_header_id,
185: NULL, -- line_id
186: 'PO_INV_CR_INVALID_MATCH_OPTION',
187: 'PO_LINE_LOCATIONS', -- table_name
188: 'MATCH_OPTION', -- column_name
189: null,
190: null, null, null, null, null,
191: null,