DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_BATCH_PKG dependencies on WSH_DELIVERY_DETAILS

Line 5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,

1: PACKAGE WSH_SHIPMENT_BATCH_PKG AUTHID CURRENT_USER AS
2: /* $Header: WSHSBPKS.pls 120.0.12020000.2 2013/01/17 03:57:11 ueshanka ship $ */
3:
4: TYPE Shipment_Batch_Record IS RECORD (
5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,

Line 6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,

2: /* $Header: WSHSBPKS.pls 120.0.12020000.2 2013/01/17 03:57:11 ueshanka ship $ */
3:
4: TYPE Shipment_Batch_Record IS RECORD (
5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,

Line 7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,

3:
4: TYPE Shipment_Batch_Record IS RECORD (
5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,

Line 8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,

4: TYPE Shipment_Batch_Record IS RECORD (
5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,

Line 9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,

5: customer_id WSH_DELIVERY_DETAILS.customer_id%TYPE,
6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,

Line 10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,

6: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
7: ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%TYPE,
8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,

Line 12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,

8: org_id WSH_DELIVERY_DETAILS.org_id%TYPE,
9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,

Line 13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,

9: currency_code WSH_DELIVERY_DETAILS.currency_code%TYPE,
10: ship_to_site_use_id WSH_DELIVERY_DETAILS.ship_to_site_use_id%TYPE,
11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,

Line 15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,

11: invoice_to_site_use_id NUMBER,
12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,
18: fob_code WSH_DELIVERY_DETAILS.fob_code%TYPE,
19: group_id NUMBER );

Line 16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,

12: deliver_to_site_use_id WSH_DELIVERY_DETAILS.deliver_to_site_use_id%TYPE,
13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,
18: fob_code WSH_DELIVERY_DETAILS.fob_code%TYPE,
19: group_id NUMBER );
20:

Line 17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,

13: ship_to_contact_id WSH_DELIVERY_DETAILS.ship_to_contact_id%TYPE,
14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,
18: fob_code WSH_DELIVERY_DETAILS.fob_code%TYPE,
19: group_id NUMBER );
20:
21: TYPE Shipment_Batch_Tbl IS TABLE OF Shipment_Batch_Record index by binary_integer;

Line 18: fob_code WSH_DELIVERY_DETAILS.fob_code%TYPE,

14: invoice_to_contact_id NUMBER,
15: deliver_to_contact_id WSH_DELIVERY_DETAILS.deliver_to_contact_id%TYPE,
16: ship_method_code WSH_DELIVERY_DETAILS.ship_method_code%TYPE,
17: freight_terms_code WSH_DELIVERY_DETAILS.freight_terms_code%TYPE,
18: fob_code WSH_DELIVERY_DETAILS.fob_code%TYPE,
19: group_id NUMBER );
20:
21: TYPE Shipment_Batch_Tbl IS TABLE OF Shipment_Batch_Record index by binary_integer;
22: