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 39: po_line_locations.price_override%TYPE INDEX BY BINARY_INTEGER;

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

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

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

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

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

Line 205: PO_LINE_LOCATIONS poll,

201: PO_VENDOR_SITES pvs,
202: PO_VENDOR_SITES pvs2,
203: PO_HEADERS poh,
204: PO_LINES pol,
205: PO_LINE_LOCATIONS poll,
206: PO_DISTRIBUTIONS pod
207: WHERE
208: pv.vendor_id = poh.vendor_id
209: AND poh.vendor_site_id = pvs.vendor_site_id

Line 270: PO_LINE_LOCATIONS poll,

266: PO_VENDOR_SITES pvs2,
267: PO_HEADERS poh,
268: PO_RELEASES por,
269: PO_LINES pol,
270: PO_LINE_LOCATIONS poll,
271: PO_DISTRIBUTIONS pod
272: WHERE
273: pv.vendor_id = poh.vendor_id
274: AND poh.vendor_site_id = pvs.vendor_site_id

Line 353: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;

349: Bug: 5125624
350: ==================================================================*/
351:
352: FUNCTION get_ship_to_location_id (p_po_line_location_id IN NUMBER)
353: RETURN PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
354:
355:
356: /* =================================================================
357: FUNCTION NAME: get_tax_classification_code(p_trx_id,p_entity_code)