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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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: --===================
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