eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on WSH_DEL_DETAILS_INTERFACE

Line 70: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,

66: client_code VARCHAR2(10) --LSP PROJECT
67: );
68:
69: TYPE Del_Details_Interface_Rec_Type IS RECORD (
70: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
71: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
72: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
73: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,

Line 71: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,

67: );
68:
69: TYPE Del_Details_Interface_Rec_Type IS RECORD (
70: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
71: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
72: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
73: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,

Line 72: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,

68:
69: TYPE Del_Details_Interface_Rec_Type IS RECORD (
70: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
71: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
72: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
73: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,

Line 73: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,

69: TYPE Del_Details_Interface_Rec_Type IS RECORD (
70: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
71: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
72: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
73: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,

Line 74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,

70: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
71: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
72: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
73: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,

Line 75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,

71: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
72: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
73: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,

Line 76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,

72: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
73: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,

Line 77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,

73: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,

Line 78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,

74: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,
82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,

Line 79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,

75: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,
82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,

Line 80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,

76: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,
82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,

Line 81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,

77: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,
82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,

Line 82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,

78: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,
82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,

Line 83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,

79: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,
82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,
87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,

Line 84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,

80: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,
82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,
87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,

Line 85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,

81: organization_id WSH_DEL_DETAILS_INTERFACE.organization_id%TYPE,
82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,
87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,

Line 86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,

82: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,
87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,

Line 87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,

83: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,
87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,

Line 88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,

84: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,
87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,

Line 89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,

85: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,
87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,

Line 90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,

86: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE,
87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,

Line 91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,

87: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,

Line 92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,

88: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,

Line 93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,

89: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,

Line 94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,

90: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,

Line 95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,

91: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,

Line 96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,

92: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
100: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,

Line 97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,

93: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
100: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
101: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,

Line 98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,

94: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
100: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
101: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
102: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,

Line 99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,

95: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
100: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
101: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
102: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
103: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,

Line 100: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,

96: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
100: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
101: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
102: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
103: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
104: line_id NUMBER,

Line 101: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,

97: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
100: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
101: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
102: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
103: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
104: line_id NUMBER,
105: schedule_date_changed VARCHAR2(1) := 'N',

Line 102: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,

98: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
100: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
101: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
102: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
103: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
104: line_id NUMBER,
105: schedule_date_changed VARCHAR2(1) := 'N',
106: changed_flag VARCHAR2(1) := 'N'

Line 103: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,

99: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
100: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
101: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
102: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
103: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
104: line_id NUMBER,
105: schedule_date_changed VARCHAR2(1) := 'N',
106: changed_flag VARCHAR2(1) := 'N'
107: );

Line 435: -- populated in Wsh_Del_Details_Interface table.

431: -- x_return_status => Return Status of API (Either S,E,U)
432: --
433: -- COMMENT:
434: -- API to derive/validate standalone related order line attributes
435: -- populated in Wsh_Del_Details_Interface table.
436: --=============================================================================
437: --
438: PROCEDURE Derive_Line_Rec(
439: p_header_id IN NUMBER,