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 68: lot_number wsh_delivery_details.lot_number%type ,

64:
65: TYPE SHIP_LINES_Rec_Type IS RECORD
66: (
67: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,
68: lot_number wsh_delivery_details.lot_number%type ,
69: revision wsh_delivery_details.revision%type ,
70: subinv wsh_delivery_details.subinventory%type ,
71: requested_quantity wsh_delivery_details.requested_quantity%type,
72: shipped_quantity wsh_delivery_details.shipped_quantity%type,

Line 69: revision wsh_delivery_details.revision%type ,

65: TYPE SHIP_LINES_Rec_Type IS RECORD
66: (
67: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,
68: lot_number wsh_delivery_details.lot_number%type ,
69: revision wsh_delivery_details.revision%type ,
70: subinv wsh_delivery_details.subinventory%type ,
71: requested_quantity wsh_delivery_details.requested_quantity%type,
72: shipped_quantity wsh_delivery_details.shipped_quantity%type,
73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,

Line 70: subinv wsh_delivery_details.subinventory%type ,

66: (
67: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,
68: lot_number wsh_delivery_details.lot_number%type ,
69: revision wsh_delivery_details.revision%type ,
70: subinv wsh_delivery_details.subinventory%type ,
71: requested_quantity wsh_delivery_details.requested_quantity%type,
72: shipped_quantity wsh_delivery_details.shipped_quantity%type,
73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,

Line 71: requested_quantity wsh_delivery_details.requested_quantity%type,

67: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,
68: lot_number wsh_delivery_details.lot_number%type ,
69: revision wsh_delivery_details.revision%type ,
70: subinv wsh_delivery_details.subinventory%type ,
71: requested_quantity wsh_delivery_details.requested_quantity%type,
72: shipped_quantity wsh_delivery_details.shipped_quantity%type,
73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,

Line 72: shipped_quantity wsh_delivery_details.shipped_quantity%type,

68: lot_number wsh_delivery_details.lot_number%type ,
69: revision wsh_delivery_details.revision%type ,
70: subinv wsh_delivery_details.subinventory%type ,
71: requested_quantity wsh_delivery_details.requested_quantity%type,
72: shipped_quantity wsh_delivery_details.shipped_quantity%type,
73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
76: organization_id wsh_delivery_details.organization_id%type,

Line 73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,

69: revision wsh_delivery_details.revision%type ,
70: subinv wsh_delivery_details.subinventory%type ,
71: requested_quantity wsh_delivery_details.requested_quantity%type,
72: shipped_quantity wsh_delivery_details.shipped_quantity%type,
73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
76: organization_id wsh_delivery_details.organization_id%type,
77: order_number wsh_delivery_details.source_header_number%type ,

Line 74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,

70: subinv wsh_delivery_details.subinventory%type ,
71: requested_quantity wsh_delivery_details.requested_quantity%type,
72: shipped_quantity wsh_delivery_details.shipped_quantity%type,
73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
76: organization_id wsh_delivery_details.organization_id%type,
77: order_number wsh_delivery_details.source_header_number%type ,
78: sales_order_header wsh_delivery_details.source_header_id%type ,

Line 75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,

71: requested_quantity wsh_delivery_details.requested_quantity%type,
72: shipped_quantity wsh_delivery_details.shipped_quantity%type,
73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
76: organization_id wsh_delivery_details.organization_id%type,
77: order_number wsh_delivery_details.source_header_number%type ,
78: sales_order_header wsh_delivery_details.source_header_id%type ,
79: locator_id wsh_delivery_details.locator_id%type,

Line 76: organization_id wsh_delivery_details.organization_id%type,

72: shipped_quantity wsh_delivery_details.shipped_quantity%type,
73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
76: organization_id wsh_delivery_details.organization_id%type,
77: order_number wsh_delivery_details.source_header_number%type ,
78: sales_order_header wsh_delivery_details.source_header_id%type ,
79: locator_id wsh_delivery_details.locator_id%type,
80: order_line_number oe_order_lines_all.line_number%type ,

Line 77: order_number wsh_delivery_details.source_header_number%type ,

73: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
76: organization_id wsh_delivery_details.organization_id%type,
77: order_number wsh_delivery_details.source_header_number%type ,
78: sales_order_header wsh_delivery_details.source_header_id%type ,
79: locator_id wsh_delivery_details.locator_id%type,
80: order_line_number oe_order_lines_all.line_number%type ,
81: date_shipped oe_order_lines_all.actual_shipment_date%type ,

Line 78: sales_order_header wsh_delivery_details.source_header_id%type ,

74: shipped_uom wsh_delivery_details.requested_quantity_uom%type ,
75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
76: organization_id wsh_delivery_details.organization_id%type,
77: order_number wsh_delivery_details.source_header_number%type ,
78: sales_order_header wsh_delivery_details.source_header_id%type ,
79: locator_id wsh_delivery_details.locator_id%type,
80: order_line_number oe_order_lines_all.line_number%type ,
81: date_shipped oe_order_lines_all.actual_shipment_date%type ,
82: line_id oe_order_lines_all.line_id%type , --Bug#6779806

Line 79: locator_id wsh_delivery_details.locator_id%type,

75: inventory_item_id wsh_delivery_details.inventory_item_id%type ,
76: organization_id wsh_delivery_details.organization_id%type,
77: order_number wsh_delivery_details.source_header_number%type ,
78: sales_order_header wsh_delivery_details.source_header_id%type ,
79: locator_id wsh_delivery_details.locator_id%type,
80: order_line_number oe_order_lines_all.line_number%type ,
81: date_shipped oe_order_lines_all.actual_shipment_date%type ,
82: line_id oe_order_lines_all.line_id%type , --Bug#6779806
83: repair_number csd_repairs.repair_number%type,

Line 105: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,

101: req_line_id oe_order_lines_all.source_document_line_id%type ,
102: req_number oe_order_lines_all.orig_sys_document_ref%type ,
103: inventory_item_id oe_order_lines_all.inventory_item_id%type,
104: shipment_date oe_order_lines_all.actual_shipment_date%type ,
105: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
106: shipped_quantity wsh_delivery_details.shipped_quantity%type,
107: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
108: lot_number wsh_delivery_details .lot_number%type,
109: subinventory wsh_delivery_details .subinventory%type,

Line 106: shipped_quantity wsh_delivery_details.shipped_quantity%type,

102: req_number oe_order_lines_all.orig_sys_document_ref%type ,
103: inventory_item_id oe_order_lines_all.inventory_item_id%type,
104: shipment_date oe_order_lines_all.actual_shipment_date%type ,
105: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
106: shipped_quantity wsh_delivery_details.shipped_quantity%type,
107: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
108: lot_number wsh_delivery_details .lot_number%type,
109: subinventory wsh_delivery_details .subinventory%type,
110: locator_id wsh_delivery_details .locator_id%type,

Line 108: lot_number wsh_delivery_details .lot_number%type,

104: shipment_date oe_order_lines_all.actual_shipment_date%type ,
105: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
106: shipped_quantity wsh_delivery_details.shipped_quantity%type,
107: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
108: lot_number wsh_delivery_details .lot_number%type,
109: subinventory wsh_delivery_details .subinventory%type,
110: locator_id wsh_delivery_details .locator_id%type,
111: organization_id wsh_delivery_details .organization_id%type,
112: released_status wsh_delivery_details .released_status%type,

Line 109: subinventory wsh_delivery_details .subinventory%type,

105: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
106: shipped_quantity wsh_delivery_details.shipped_quantity%type,
107: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
108: lot_number wsh_delivery_details .lot_number%type,
109: subinventory wsh_delivery_details .subinventory%type,
110: locator_id wsh_delivery_details .locator_id%type,
111: organization_id wsh_delivery_details .organization_id%type,
112: released_status wsh_delivery_details .released_status%type,
113: requested_quantity wsh_delivery_details .requested_quantity%type,

Line 110: locator_id wsh_delivery_details .locator_id%type,

106: shipped_quantity wsh_delivery_details.shipped_quantity%type,
107: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
108: lot_number wsh_delivery_details .lot_number%type,
109: subinventory wsh_delivery_details .subinventory%type,
110: locator_id wsh_delivery_details .locator_id%type,
111: organization_id wsh_delivery_details .organization_id%type,
112: released_status wsh_delivery_details .released_status%type,
113: requested_quantity wsh_delivery_details .requested_quantity%type,
114: order_number wsh_delivery_details .source_header_number%type ,

Line 111: organization_id wsh_delivery_details .organization_id%type,

107: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
108: lot_number wsh_delivery_details .lot_number%type,
109: subinventory wsh_delivery_details .subinventory%type,
110: locator_id wsh_delivery_details .locator_id%type,
111: organization_id wsh_delivery_details .organization_id%type,
112: released_status wsh_delivery_details .released_status%type,
113: requested_quantity wsh_delivery_details .requested_quantity%type,
114: order_number wsh_delivery_details .source_header_number%type ,
115: source_organization_id po_requisition_lines_all.source_organization_id%type,

Line 112: released_status wsh_delivery_details .released_status%type,

108: lot_number wsh_delivery_details .lot_number%type,
109: subinventory wsh_delivery_details .subinventory%type,
110: locator_id wsh_delivery_details .locator_id%type,
111: organization_id wsh_delivery_details .organization_id%type,
112: released_status wsh_delivery_details .released_status%type,
113: requested_quantity wsh_delivery_details .requested_quantity%type,
114: order_number wsh_delivery_details .source_header_number%type ,
115: source_organization_id po_requisition_lines_all.source_organization_id%type,
116: source_subinventory po_requisition_lines_all.source_subinventory%type,

Line 113: requested_quantity wsh_delivery_details .requested_quantity%type,

109: subinventory wsh_delivery_details .subinventory%type,
110: locator_id wsh_delivery_details .locator_id%type,
111: organization_id wsh_delivery_details .organization_id%type,
112: released_status wsh_delivery_details .released_status%type,
113: requested_quantity wsh_delivery_details .requested_quantity%type,
114: order_number wsh_delivery_details .source_header_number%type ,
115: source_organization_id po_requisition_lines_all.source_organization_id%type,
116: source_subinventory po_requisition_lines_all.source_subinventory%type,
117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,

Line 114: order_number wsh_delivery_details .source_header_number%type ,

110: locator_id wsh_delivery_details .locator_id%type,
111: organization_id wsh_delivery_details .organization_id%type,
112: released_status wsh_delivery_details .released_status%type,
113: requested_quantity wsh_delivery_details .requested_quantity%type,
114: order_number wsh_delivery_details .source_header_number%type ,
115: source_organization_id po_requisition_lines_all.source_organization_id%type,
116: source_subinventory po_requisition_lines_all.source_subinventory%type,
117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,

Line 6185: wsh_delivery_details dd ,

6181: from
6182: csd_product_transactions cpt,
6183: cs_estimate_details ced,
6184: csd_repairs cra,
6185: wsh_delivery_details dd ,
6186: wsh_serial_numbers dsn,--Added to fix 3801614
6187: --Changed to view from table, bug: 4341784
6188: wsh_delivery_assignments_v wda,
6189: wsh_new_deliveries wnd,

Line 6261: wsh_delivery_details dd ,

6257: from
6258: csd_product_transactions cpt,
6259: cs_estimate_details ced,
6260: csd_repairs cra,
6261: wsh_delivery_details dd ,
6262: wsh_serial_numbers dsn,--Added to fix 3801614
6263: --Changed to view from table, bug: 4341784
6264: wsh_delivery_assignments_v wda,
6265: wsh_new_deliveries wnd,

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

6305:
6306: -- 12.1 FP bug#7551078, subhat.
6307: -- need to pick up only those ship lines which have source type as OE.
6308: -- There can be multiple delivery lines for the same sales order or
6309: -- the source_line_id in wsh_delivery_details can be same for OKE ship lines and
6310: -- OE ship lines.
6311: Cursor SHIPMENT_LINES ( p_repair_line_id in number) is
6312: select
6313: ---changed to fix 3801614 , added dsn.serial_number if dd.serial_number is null

Line 6345: wsh_delivery_details dd ,

6341: from
6342: csd_product_transactions cpt,
6343: cs_estimate_details ced,
6344: csd_repairs cra,
6345: wsh_delivery_details dd ,
6346: wsh_serial_numbers dsn,--Added to fix 3801614
6347: --Changed to view from table, bug: 4341784
6348: wsh_delivery_assignments_v wda,
6349: wsh_new_deliveries wnd,

Line 7037: wsh_delivery_details dd,

7033: hao.name source_org_name,
7034: hao1.name destination_org_name,
7035: trl.txn_source_id
7036: from oe_order_lines_all oel,
7037: wsh_delivery_details dd,
7038: wsh_serial_numbers dsn,--Added to fix 3801614
7039: po_requisition_lines_all prl,
7040: po_requisition_headers_all prh,
7041: mtl_system_items mtl,

Line 7094: wsh_delivery_details dd,

7090: hao.name source_org_name,
7091: hao1.name destination_org_name,
7092: trl.txn_source_id
7093: from oe_order_lines_all oel,
7094: wsh_delivery_details dd,
7095: wsh_serial_numbers dsn,--Added to fix 3801614
7096: po_requisition_lines_all prl,
7097: po_requisition_headers_all prh,
7098: mtl_system_items mtl,

Line 8044: wsh_delivery_details wdd

8040: (select
8041: mut.serial_number
8042: from mtl_material_transactions mtl,
8043: mtl_unit_transactions mut,
8044: wsh_delivery_details wdd
8045: where mtl.transaction_id = mut.transaction_id
8046: and mtl.transaction_source_type_id = 8 -- Internal Order
8047: and mtl.transaction_type_id in ( 50,62,54,34)
8048: and mtl.transaction_source_id = DEL.txn_source_id

Line 8300: wsh_delivery_details wdd

8296: (select
8297: mut.serial_number
8298: from mtl_material_transactions mtl,
8299: mtl_unit_transactions mut,
8300: wsh_delivery_details wdd
8301: where mtl.transaction_id = mut.transaction_id
8302: and mtl.transaction_source_type_id = 8 -- Internal Order
8303: and mtl.transaction_type_id in ( 50,62,54,34)
8304: and mtl.transaction_source_id = DEL.txn_source_id