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.CSD_UPDATE_PROGRAMS_PVT dependencies on WSH_DELIVERY_DETAILS

Line 74: lot_number wsh_delivery_details.lot_number%type ,

70:
71: TYPE SHIP_LINES_Rec_Type IS RECORD
72: (
73: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,
74: lot_number wsh_delivery_details.lot_number%type ,
75: revision wsh_delivery_details.revision%type ,
76: subinv wsh_delivery_details.subinventory%type ,
77: requested_quantity wsh_delivery_details.requested_quantity%type,
78: shipped_quantity wsh_delivery_details.shipped_quantity%type,

Line 75: revision wsh_delivery_details.revision%type ,

71: TYPE SHIP_LINES_Rec_Type IS RECORD
72: (
73: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,
74: lot_number wsh_delivery_details.lot_number%type ,
75: revision wsh_delivery_details.revision%type ,
76: subinv wsh_delivery_details.subinventory%type ,
77: requested_quantity wsh_delivery_details.requested_quantity%type,
78: shipped_quantity wsh_delivery_details.shipped_quantity%type,
79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,

Line 76: subinv wsh_delivery_details.subinventory%type ,

72: (
73: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,
74: lot_number wsh_delivery_details.lot_number%type ,
75: revision wsh_delivery_details.revision%type ,
76: subinv wsh_delivery_details.subinventory%type ,
77: requested_quantity wsh_delivery_details.requested_quantity%type,
78: shipped_quantity wsh_delivery_details.shipped_quantity%type,
79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,

Line 77: requested_quantity wsh_delivery_details.requested_quantity%type,

73: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,
74: lot_number wsh_delivery_details.lot_number%type ,
75: revision wsh_delivery_details.revision%type ,
76: subinv wsh_delivery_details.subinventory%type ,
77: requested_quantity wsh_delivery_details.requested_quantity%type,
78: shipped_quantity wsh_delivery_details.shipped_quantity%type,
79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,

Line 78: shipped_quantity wsh_delivery_details.shipped_quantity%type,

74: lot_number wsh_delivery_details.lot_number%type ,
75: revision wsh_delivery_details.revision%type ,
76: subinv wsh_delivery_details.subinventory%type ,
77: requested_quantity wsh_delivery_details.requested_quantity%type,
78: shipped_quantity wsh_delivery_details.shipped_quantity%type,
79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
82: organization_id wsh_delivery_details.organization_id%type,

Line 79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,

75: revision wsh_delivery_details.revision%type ,
76: subinv wsh_delivery_details.subinventory%type ,
77: requested_quantity wsh_delivery_details.requested_quantity%type,
78: shipped_quantity wsh_delivery_details.shipped_quantity%type,
79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
82: organization_id wsh_delivery_details.organization_id%type,
83: order_number wsh_delivery_details.source_header_number%type ,

Line 80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,

76: subinv wsh_delivery_details.subinventory%type ,
77: requested_quantity wsh_delivery_details.requested_quantity%type,
78: shipped_quantity wsh_delivery_details.shipped_quantity%type,
79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
82: organization_id wsh_delivery_details.organization_id%type,
83: order_number wsh_delivery_details.source_header_number%type ,
84: sales_order_header wsh_delivery_details.source_header_id%type ,

Line 81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,

77: requested_quantity wsh_delivery_details.requested_quantity%type,
78: shipped_quantity wsh_delivery_details.shipped_quantity%type,
79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
82: organization_id wsh_delivery_details.organization_id%type,
83: order_number wsh_delivery_details.source_header_number%type ,
84: sales_order_header wsh_delivery_details.source_header_id%type ,
85: locator_id wsh_delivery_details.locator_id%type,

Line 82: organization_id wsh_delivery_details.organization_id%type,

78: shipped_quantity wsh_delivery_details.shipped_quantity%type,
79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
82: organization_id wsh_delivery_details.organization_id%type,
83: order_number wsh_delivery_details.source_header_number%type ,
84: sales_order_header wsh_delivery_details.source_header_id%type ,
85: locator_id wsh_delivery_details.locator_id%type,
86: released_status wsh_delivery_details.released_status%type, --bug#14657082 --bug#15859195

Line 83: order_number wsh_delivery_details.source_header_number%type ,

79: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
82: organization_id wsh_delivery_details.organization_id%type,
83: order_number wsh_delivery_details.source_header_number%type ,
84: sales_order_header wsh_delivery_details.source_header_id%type ,
85: locator_id wsh_delivery_details.locator_id%type,
86: released_status wsh_delivery_details.released_status%type, --bug#14657082 --bug#15859195
87: order_line_number oe_order_lines_all.line_number%type ,

Line 84: sales_order_header wsh_delivery_details.source_header_id%type ,

80: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
82: organization_id wsh_delivery_details.organization_id%type,
83: order_number wsh_delivery_details.source_header_number%type ,
84: sales_order_header wsh_delivery_details.source_header_id%type ,
85: locator_id wsh_delivery_details.locator_id%type,
86: released_status wsh_delivery_details.released_status%type, --bug#14657082 --bug#15859195
87: order_line_number oe_order_lines_all.line_number%type ,
88: date_shipped oe_order_lines_all.actual_shipment_date%type ,

Line 85: locator_id wsh_delivery_details.locator_id%type,

81: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
82: organization_id wsh_delivery_details.organization_id%type,
83: order_number wsh_delivery_details.source_header_number%type ,
84: sales_order_header wsh_delivery_details.source_header_id%type ,
85: locator_id wsh_delivery_details.locator_id%type,
86: released_status wsh_delivery_details.released_status%type, --bug#14657082 --bug#15859195
87: order_line_number oe_order_lines_all.line_number%type ,
88: date_shipped oe_order_lines_all.actual_shipment_date%type ,
89: line_id oe_order_lines_all.line_id%type , --Bug#6779806

Line 86: released_status wsh_delivery_details.released_status%type, --bug#14657082 --bug#15859195

82: organization_id wsh_delivery_details.organization_id%type,
83: order_number wsh_delivery_details.source_header_number%type ,
84: sales_order_header wsh_delivery_details.source_header_id%type ,
85: locator_id wsh_delivery_details.locator_id%type,
86: released_status wsh_delivery_details.released_status%type, --bug#14657082 --bug#15859195
87: order_line_number oe_order_lines_all.line_number%type ,
88: date_shipped oe_order_lines_all.actual_shipment_date%type ,
89: line_id oe_order_lines_all.line_id%type , --Bug#6779806
90: repair_number csd_repairs.repair_number%type,

Line 112: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,

108: req_line_id oe_order_lines_all.source_document_line_id%type ,
109: req_number oe_order_lines_all.orig_sys_document_ref%type ,
110: inventory_item_id oe_order_lines_all.inventory_item_id%type,
111: shipment_date oe_order_lines_all.actual_shipment_date%type ,
112: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
113: shipped_quantity wsh_delivery_details.shipped_quantity%type,
114: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
115: lot_number wsh_delivery_details .lot_number%type,
116: subinventory wsh_delivery_details .subinventory%type,

Line 113: shipped_quantity wsh_delivery_details.shipped_quantity%type,

109: req_number oe_order_lines_all.orig_sys_document_ref%type ,
110: inventory_item_id oe_order_lines_all.inventory_item_id%type,
111: shipment_date oe_order_lines_all.actual_shipment_date%type ,
112: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
113: shipped_quantity wsh_delivery_details.shipped_quantity%type,
114: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
115: lot_number wsh_delivery_details .lot_number%type,
116: subinventory wsh_delivery_details .subinventory%type,
117: locator_id wsh_delivery_details .locator_id%type,

Line 115: lot_number wsh_delivery_details .lot_number%type,

111: shipment_date oe_order_lines_all.actual_shipment_date%type ,
112: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
113: shipped_quantity wsh_delivery_details.shipped_quantity%type,
114: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
115: lot_number wsh_delivery_details .lot_number%type,
116: subinventory wsh_delivery_details .subinventory%type,
117: locator_id wsh_delivery_details .locator_id%type,
118: organization_id wsh_delivery_details .organization_id%type,
119: released_status wsh_delivery_details .released_status%type,

Line 116: subinventory wsh_delivery_details .subinventory%type,

112: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
113: shipped_quantity wsh_delivery_details.shipped_quantity%type,
114: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
115: lot_number wsh_delivery_details .lot_number%type,
116: subinventory wsh_delivery_details .subinventory%type,
117: locator_id wsh_delivery_details .locator_id%type,
118: organization_id wsh_delivery_details .organization_id%type,
119: released_status wsh_delivery_details .released_status%type,
120: requested_quantity wsh_delivery_details .requested_quantity%type,

Line 117: locator_id wsh_delivery_details .locator_id%type,

113: shipped_quantity wsh_delivery_details.shipped_quantity%type,
114: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
115: lot_number wsh_delivery_details .lot_number%type,
116: subinventory wsh_delivery_details .subinventory%type,
117: locator_id wsh_delivery_details .locator_id%type,
118: organization_id wsh_delivery_details .organization_id%type,
119: released_status wsh_delivery_details .released_status%type,
120: requested_quantity wsh_delivery_details .requested_quantity%type,
121: order_number wsh_delivery_details .source_header_number%type ,

Line 118: organization_id wsh_delivery_details .organization_id%type,

114: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
115: lot_number wsh_delivery_details .lot_number%type,
116: subinventory wsh_delivery_details .subinventory%type,
117: locator_id wsh_delivery_details .locator_id%type,
118: organization_id wsh_delivery_details .organization_id%type,
119: released_status wsh_delivery_details .released_status%type,
120: requested_quantity wsh_delivery_details .requested_quantity%type,
121: order_number wsh_delivery_details .source_header_number%type ,
122: source_organization_id po_requisition_lines_all.source_organization_id%type,

Line 119: released_status wsh_delivery_details .released_status%type,

115: lot_number wsh_delivery_details .lot_number%type,
116: subinventory wsh_delivery_details .subinventory%type,
117: locator_id wsh_delivery_details .locator_id%type,
118: organization_id wsh_delivery_details .organization_id%type,
119: released_status wsh_delivery_details .released_status%type,
120: requested_quantity wsh_delivery_details .requested_quantity%type,
121: order_number wsh_delivery_details .source_header_number%type ,
122: source_organization_id po_requisition_lines_all.source_organization_id%type,
123: source_subinventory po_requisition_lines_all.source_subinventory%type,

Line 120: requested_quantity wsh_delivery_details .requested_quantity%type,

116: subinventory wsh_delivery_details .subinventory%type,
117: locator_id wsh_delivery_details .locator_id%type,
118: organization_id wsh_delivery_details .organization_id%type,
119: released_status wsh_delivery_details .released_status%type,
120: requested_quantity wsh_delivery_details .requested_quantity%type,
121: order_number wsh_delivery_details .source_header_number%type ,
122: source_organization_id po_requisition_lines_all.source_organization_id%type,
123: source_subinventory po_requisition_lines_all.source_subinventory%type,
124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,

Line 121: order_number wsh_delivery_details .source_header_number%type ,

117: locator_id wsh_delivery_details .locator_id%type,
118: organization_id wsh_delivery_details .organization_id%type,
119: released_status wsh_delivery_details .released_status%type,
120: requested_quantity wsh_delivery_details .requested_quantity%type,
121: order_number wsh_delivery_details .source_header_number%type ,
122: source_organization_id po_requisition_lines_all.source_organization_id%type,
123: source_subinventory po_requisition_lines_all.source_subinventory%type,
124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,

Line 6385: wsh_delivery_details dd ,

6381: from
6382: csd_product_transactions cpt,
6383: cs_estimate_details ced,
6384: csd_repairs cra,
6385: wsh_delivery_details dd ,
6386: wsh_serial_numbers dsn,--Added to fix 3801614
6387: --Changed to view from table, bug: 4341784
6388: wsh_delivery_assignments_v wda,
6389: wsh_new_deliveries wnd,

Line 6462: wsh_delivery_details dd ,

6458: from
6459: csd_product_transactions cpt,
6460: cs_estimate_details ced,
6461: csd_repairs cra,
6462: wsh_delivery_details dd ,
6463: wsh_serial_numbers dsn,--Added to fix 3801614
6464: --Changed to view from table, bug: 4341784
6465: wsh_delivery_assignments_v wda,
6466: wsh_new_deliveries wnd,

Line 6510: -- the source_line_id in wsh_delivery_details can be same for OKE ship lines and

6506:
6507: -- 12.1 FP bug#7551078, subhat.
6508: -- need to pick up only those ship lines which have source type as OE.
6509: -- There can be multiple delivery lines for the same sales order or
6510: -- the source_line_id in wsh_delivery_details can be same for OKE ship lines and
6511: -- OE ship lines.
6512: Cursor SHIPMENT_LINES ( p_repair_line_id in number) is
6513: select
6514: ---changed to fix 3801614 , added dsn.serial_number if dd.serial_number is null

Line 6547: wsh_delivery_details dd ,

6543: from
6544: csd_product_transactions cpt,
6545: cs_estimate_details ced,
6546: csd_repairs cra,
6547: wsh_delivery_details dd ,
6548: wsh_serial_numbers dsn,--Added to fix 3801614
6549: --Changed to view from table, bug: 4341784
6550: wsh_delivery_assignments_v wda,
6551: wsh_new_deliveries wnd,

Line 7329: wsh_delivery_details dd,

7325: hao.name source_org_name,
7326: hao1.name destination_org_name,
7327: trl.txn_source_id
7328: from oe_order_lines_all oel,
7329: wsh_delivery_details dd,
7330: wsh_serial_numbers dsn,--Added to fix 3801614
7331: po_requisition_lines_all prl,
7332: po_requisition_headers_all prh,
7333: mtl_system_items mtl,

Line 7386: wsh_delivery_details dd,

7382: hao.name source_org_name,
7383: hao1.name destination_org_name,
7384: trl.txn_source_id
7385: from oe_order_lines_all oel,
7386: wsh_delivery_details dd,
7387: wsh_serial_numbers dsn,--Added to fix 3801614
7388: po_requisition_lines_all prl,
7389: po_requisition_headers_all prh,
7390: mtl_system_items mtl,

Line 8336: wsh_delivery_details wdd

8332: (select
8333: mut.serial_number
8334: from mtl_material_transactions mtl,
8335: mtl_unit_transactions mut,
8336: wsh_delivery_details wdd
8337: where mtl.transaction_id = mut.transaction_id
8338: and mtl.transaction_source_type_id = 8 -- Internal Order
8339: and mtl.transaction_type_id in ( 50,62,54,34)
8340: and mtl.transaction_source_id = DEL.txn_source_id

Line 8592: wsh_delivery_details wdd

8588: (select
8589: mut.serial_number
8590: from mtl_material_transactions mtl,
8591: mtl_unit_transactions mut,
8592: wsh_delivery_details wdd
8593: where mtl.transaction_id = mut.transaction_id
8594: and mtl.transaction_source_type_id = 8 -- Internal Order
8595: and mtl.transaction_type_id in ( 50,62,54,34)
8596: and mtl.transaction_source_id = DEL.txn_source_id