DBA Data[Home] [Help]

APPS.PO_ADVANCED_PRICE_PVT dependencies on PO_HEADERS

Line 13: ( org_id PO_HEADERS.org_id%TYPE

9: -- Package types
10: -------------------------------------------------------------------------------
11: -- Header record type
12: TYPE Header_Rec_Type IS RECORD
13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE

Line 14: , p_order_header_id PO_HEADERS.po_header_id%TYPE

10: -------------------------------------------------------------------------------
11: -- Header record type
12: TYPE Header_Rec_Type IS RECORD
13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO

Line 15: , supplier_id PO_HEADERS.vendor_id%TYPE

11: -- Header record type
12: TYPE Header_Rec_Type IS RECORD
13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE

Line 16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE

12: TYPE Header_Rec_Type IS RECORD
13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE
20: , ship_to_org_id PO_HEADERS.org_id%TYPE

Line 17: , creation_date PO_HEADERS.creation_date%TYPE

13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE
20: , ship_to_org_id PO_HEADERS.org_id%TYPE
21: -- New Attributes for Receiving

Line 19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE

15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE
20: , ship_to_org_id PO_HEADERS.org_id%TYPE
21: -- New Attributes for Receiving
22: --
23: , shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE

Line 20: , ship_to_org_id PO_HEADERS.org_id%TYPE

16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE
20: , ship_to_org_id PO_HEADERS.org_id%TYPE
21: -- New Attributes for Receiving
22: --
23: , shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
24: , hazard_class RCV_SHIPMENT_HEADERS.hazard_class%TYPE

Line 43: , agreement_type PO_HEADERS.type_lookup_code%TYPE

39:
40: -- Line record type
41: TYPE Line_Rec_Type IS RECORD
42: ( order_line_id PO_LINES.po_line_id%TYPE
43: , agreement_type PO_HEADERS.type_lookup_code%TYPE
44: , agreement_id PO_HEADERS.po_header_id%TYPE
45: , agreement_line_id PO_LINES.po_line_id%TYPE --
46: , supplier_id PO_HEADERS.vendor_id%TYPE
47: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE

Line 44: , agreement_id PO_HEADERS.po_header_id%TYPE

40: -- Line record type
41: TYPE Line_Rec_Type IS RECORD
42: ( order_line_id PO_LINES.po_line_id%TYPE
43: , agreement_type PO_HEADERS.type_lookup_code%TYPE
44: , agreement_id PO_HEADERS.po_header_id%TYPE
45: , agreement_line_id PO_LINES.po_line_id%TYPE --
46: , supplier_id PO_HEADERS.vendor_id%TYPE
47: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
48: , ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE

Line 46: , supplier_id PO_HEADERS.vendor_id%TYPE

42: ( order_line_id PO_LINES.po_line_id%TYPE
43: , agreement_type PO_HEADERS.type_lookup_code%TYPE
44: , agreement_id PO_HEADERS.po_header_id%TYPE
45: , agreement_line_id PO_LINES.po_line_id%TYPE --
46: , supplier_id PO_HEADERS.vendor_id%TYPE
47: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
48: , ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE
49: , ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE
50: , supplier_item_num PO_LINES.vendor_product_num%TYPE

Line 47: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE

43: , agreement_type PO_HEADERS.type_lookup_code%TYPE
44: , agreement_id PO_HEADERS.po_header_id%TYPE
45: , agreement_line_id PO_LINES.po_line_id%TYPE --
46: , supplier_id PO_HEADERS.vendor_id%TYPE
47: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
48: , ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE
49: , ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE
50: , supplier_item_num PO_LINES.vendor_product_num%TYPE
51: , item_revision PO_LINES.item_revision%TYPE

Line 54: , rate PO_HEADERS.rate%TYPE

50: , supplier_item_num PO_LINES.vendor_product_num%TYPE
51: , item_revision PO_LINES.item_revision%TYPE
52: , item_id PO_LINES.item_id%TYPE
53: , category_id PO_LINES.category_id%TYPE
54: , rate PO_HEADERS.rate%TYPE
55: , rate_type PO_HEADERS.rate_type%TYPE
56: , currency_code PO_HEADERS.currency_code%TYPE
57: , need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE
58: --

Line 55: , rate_type PO_HEADERS.rate_type%TYPE

51: , item_revision PO_LINES.item_revision%TYPE
52: , item_id PO_LINES.item_id%TYPE
53: , category_id PO_LINES.category_id%TYPE
54: , rate PO_HEADERS.rate%TYPE
55: , rate_type PO_HEADERS.rate_type%TYPE
56: , currency_code PO_HEADERS.currency_code%TYPE
57: , need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE
58: --
59: -- New Attributes for Receiving

Line 56: , currency_code PO_HEADERS.currency_code%TYPE

52: , item_id PO_LINES.item_id%TYPE
53: , category_id PO_LINES.category_id%TYPE
54: , rate PO_HEADERS.rate%TYPE
55: , rate_type PO_HEADERS.rate_type%TYPE
56: , currency_code PO_HEADERS.currency_code%TYPE
57: , need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE
58: --
59: -- New Attributes for Receiving
60: , shipment_line_id RCV_SHIPMENT_LINES.shipment_line_id%TYPE