APPS.PO_INVOICES_SV2 dependencies on PO_LINE_LOCATIONS

Line 18: po_line_locations.line_location_id%TYPE INDEX BY BINARY_INTEGER;

14: TYPE po_line_id_tbl_type IS TABLE OF
15: po_lines.po_line_id%TYPE INDEX BY BINARY_INTEGER;
16:
17: TYPE line_location_id_tbl_type IS TABLE OF
18: po_line_locations.line_location_id%TYPE INDEX BY BINARY_INTEGER;
19:
20: TYPE po_distribution_id_tbl_type IS TABLE OF
21: po_distributions.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
22:

Line 36: po_line_locations.price_override%TYPE INDEX BY BINARY_INTEGER;

32: TYPE item_description_tbl_type IS TABLE OF
33: PO_LINES.item_description%TYPE INDEX BY BINARY_INTEGER;
34:
35: TYPE price_override_tbl_type IS TABLE OF
36: po_line_locations.price_override%TYPE INDEX BY BINARY_INTEGER;
37:
38: TYPE quantity_tbl_type IS TABLE OF
39: po_distributions.quantity_ordered%TYPE INDEX BY BINARY_INTEGER;
40:

Line 57: po_line_locations.tax_code_id%TYPE INDEX BY BINARY_INTEGER;

53: TYPE payment_terms_id_tbl_type IS TABLE OF
54: po_headers.terms_id%TYPE INDEX BY BINARY_INTEGER;
55:
56: TYPE tax_code_id_tbl_type IS TABLE OF
57: po_line_locations.tax_code_id%TYPE INDEX BY BINARY_INTEGER;
58:
59: TYPE invoice_amount_tbl_type IS TABLE OF
60: ap_invoices_interface.invoice_amount%TYPE INDEX BY BINARY_INTEGER;
61:

Line 91: PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE INDEX BY BINARY_INTEGER;

87: ap_invoices_interface.group_id%TYPE INDEX BY BINARY_INTEGER;
88:
89: /* Bug 5100177. */
90: TYPE unit_of_meas_tbl_type IS TABLE OF
91: PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE INDEX BY BINARY_INTEGER;
92: TYPE consump_rec_type IS RECORD (
93: po_header_id po_header_id_tbl_type,
94: po_release_id po_release_id_tbl_type,
95: po_Line_id po_line_id_tbl_type,

Line 200: PO_LINE_LOCATIONS poll,

196: PO_VENDOR_SITES pvs,
197: PO_VENDOR_SITES pvs2,
198: PO_HEADERS poh,
199: PO_LINES pol,
200: PO_LINE_LOCATIONS poll,
201: PO_DISTRIBUTIONS pod
202: WHERE
203: pv.vendor_id = poh.vendor_id
204: AND poh.vendor_site_id = pvs.vendor_site_id

Line 264: PO_LINE_LOCATIONS poll,

260: PO_VENDOR_SITES pvs2,
261: PO_HEADERS poh,
262: PO_RELEASES por,
263: PO_LINES pol,
264: PO_LINE_LOCATIONS poll,
265: PO_DISTRIBUTIONS pod
266: WHERE
267: pv.vendor_id = poh.vendor_id
268: AND poh.vendor_site_id = pvs.vendor_site_id

Line 347: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

343: Bug: 5125624
344: ==================================================================*/
345:
346: FUNCTION get_ship_to_location_id (p_po_line_location_id IN NUMBER)
347: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
348:
349:
350: /* =================================================================
351: FUNCTION NAME: get_tax_classification_code(p_trx_id,p_entity_code)