DBA Data[Home] [Help]

APPS.WSH_INBOUND_TXN_HISTORY_PKG dependencies on WSH_BULK_TYPES_GRP

Line 56: TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,

52: SHIP_FROM_LOCATION_ID NUMBER); -- IB-Phase-2
53:
54: TYPE inboundTxnHistory_recTbl_type is RECORD
55: (
56: TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
57: RECEIPT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
58: REVISION_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
59: SHIPMENT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,

Line 57: RECEIPT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,

53:
54: TYPE inboundTxnHistory_recTbl_type is RECORD
55: (
56: TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
57: RECEIPT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
58: REVISION_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
59: SHIPMENT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,
61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,

Line 58: REVISION_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,

54: TYPE inboundTxnHistory_recTbl_type is RECORD
55: (
56: TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
57: RECEIPT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
58: REVISION_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
59: SHIPMENT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,
61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,

Line 59: SHIPMENT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,

55: (
56: TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
57: RECEIPT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
58: REVISION_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
59: SHIPMENT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,
61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,

Line 60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,

56: TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
57: RECEIPT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
58: REVISION_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
59: SHIPMENT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,
61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,
64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,

Line 61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,

57: RECEIPT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
58: REVISION_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
59: SHIPMENT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,
61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,
64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,
65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,

Line 62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,

58: REVISION_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
59: SHIPMENT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,
61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,
64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,
65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,
66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,

Line 63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,

59: SHIPMENT_NUMBER WSH_BULK_TYPES_GRP.tbl_v30,
60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,
61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,
64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,
65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,
66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,
67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,

Line 64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,

60: TRANSACTION_TYPE WSH_BULK_TYPES_GRP.tbl_v50,
61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,
64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,
65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,
66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,
67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,
68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,

Line 65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,

61: SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,
64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,
65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,
66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,
67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,
68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,

Line 66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,

62: PARENT_SHIPMENT_HEADER_ID WSH_BULK_TYPES_GRP.tbl_num,
63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,
64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,
65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,
66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,
67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,
68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,
70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,

Line 67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,

63: ORGANIZATION_ID WSH_BULK_TYPES_GRP.tbl_num,
64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,
65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,
66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,
67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,
68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,
70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,
71: MATCHED_BY WSH_BULK_TYPES_GRP.tbl_num,

Line 68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,

64: SUPPLIER_ID WSH_BULK_TYPES_GRP.tbl_num,
65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,
66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,
67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,
68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,
70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,
71: MATCHED_BY WSH_BULK_TYPES_GRP.tbl_num,
72: SHIPMENT_LINE_ID WSH_BULK_TYPES_GRP.tbl_num,

Line 69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,

65: SHIPPED_DATE WSH_BULK_TYPES_GRP.tbl_date,
66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,
67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,
68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,
70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,
71: MATCHED_BY WSH_BULK_TYPES_GRP.tbl_num,
72: SHIPMENT_LINE_ID WSH_BULK_TYPES_GRP.tbl_num,
73: OBJECT_VERSION_NUMBER WSH_BULK_TYPES_GRP.tbl_num,

Line 70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,

66: RECEIPT_DATE WSH_BULK_TYPES_GRP.tbl_date,
67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,
68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,
70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,
71: MATCHED_BY WSH_BULK_TYPES_GRP.tbl_num,
72: SHIPMENT_LINE_ID WSH_BULK_TYPES_GRP.tbl_num,
73: OBJECT_VERSION_NUMBER WSH_BULK_TYPES_GRP.tbl_num,
74: SHIP_FROM_LOCATION_ID WSH_BULK_TYPES_GRP.tbl_num -- IB-Phase-2

Line 71: MATCHED_BY WSH_BULK_TYPES_GRP.tbl_num,

67: STATUS WSH_BULK_TYPES_GRP.tbl_v50,
68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,
70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,
71: MATCHED_BY WSH_BULK_TYPES_GRP.tbl_num,
72: SHIPMENT_LINE_ID WSH_BULK_TYPES_GRP.tbl_num,
73: OBJECT_VERSION_NUMBER WSH_BULK_TYPES_GRP.tbl_num,
74: SHIP_FROM_LOCATION_ID WSH_BULK_TYPES_GRP.tbl_num -- IB-Phase-2
75: );

Line 72: SHIPMENT_LINE_ID WSH_BULK_TYPES_GRP.tbl_num,

68: MAX_RCV_TRANSACTION_ID WSH_BULK_TYPES_GRP.tbl_num,
69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,
70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,
71: MATCHED_BY WSH_BULK_TYPES_GRP.tbl_num,
72: SHIPMENT_LINE_ID WSH_BULK_TYPES_GRP.tbl_num,
73: OBJECT_VERSION_NUMBER WSH_BULK_TYPES_GRP.tbl_num,
74: SHIP_FROM_LOCATION_ID WSH_BULK_TYPES_GRP.tbl_num -- IB-Phase-2
75: );
76:

Line 73: OBJECT_VERSION_NUMBER WSH_BULK_TYPES_GRP.tbl_num,

69: CARRIER_ID WSH_BULK_TYPES_GRP.tbl_num,
70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,
71: MATCHED_BY WSH_BULK_TYPES_GRP.tbl_num,
72: SHIPMENT_LINE_ID WSH_BULK_TYPES_GRP.tbl_num,
73: OBJECT_VERSION_NUMBER WSH_BULK_TYPES_GRP.tbl_num,
74: SHIP_FROM_LOCATION_ID WSH_BULK_TYPES_GRP.tbl_num -- IB-Phase-2
75: );
76:
77: --===================

Line 74: SHIP_FROM_LOCATION_ID WSH_BULK_TYPES_GRP.tbl_num -- IB-Phase-2

70: MATCH_REVERTED_BY WSH_BULK_TYPES_GRP.tbl_num,
71: MATCHED_BY WSH_BULK_TYPES_GRP.tbl_num,
72: SHIPMENT_LINE_ID WSH_BULK_TYPES_GRP.tbl_num,
73: OBJECT_VERSION_NUMBER WSH_BULK_TYPES_GRP.tbl_num,
74: SHIP_FROM_LOCATION_ID WSH_BULK_TYPES_GRP.tbl_num -- IB-Phase-2
75: );
76:
77: --===================
78: -- PROCEDURES