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_REPAIRS_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 2939: po_requisition_lines_all prl,wsh_delivery_details wdd

2935: USING (SELECT ooh.header_id,ool.line_id,prl.requisition_line_id,prl.requisition_header_id,wdd.delivery_detail_id,
2936: ooh.org_id source_ou,prl.org_id destination_ou,prl.destination_organization_id dest_org,prl.source_organization_id source_org,
2937: prl.quantity,prl.item_id
2938: FROM oe_order_headers_all ooh, oe_order_lines_all ool,
2939: po_requisition_lines_all prl,wsh_delivery_details wdd
2940: WHERE ooh.source_document_id = l_requisition_id(i)
2941: AND ooh.header_id = ool.header_id
2942: AND ool.source_document_line_id = prl.requisition_line_id
2943: AND prl.requisition_header_id = l_requisition_id(i)

Line 3185: cs_estimate_details ced, csd_product_transactions cpt,wsh_delivery_details wdd,

3181:
3182: SELECT cpt.repair_line_id,oeh.header_id,ced.inventory_item_id,cr.incident_id
3183: INTO l_repair_line_id,l_header_id,l_ship_inv_item_id,l_incident_id
3184: FROM oe_order_lines_all oel, oe_order_headers_all oeh,
3185: cs_estimate_details ced, csd_product_transactions cpt,wsh_delivery_details wdd,
3186: csd_repairs cr
3187: WHERE oel.line_id = p_order_line_id
3188: AND oel.header_id = oeh.header_id
3189: AND oeh.header_id = ced.order_header_id

Line 3205: wsh_delivery_details wdd

3201: INTO l_serial_number
3202: FROM(
3203: SELECT fm_serial_number serial_number
3204: FROM wsh_serial_numbers wsn,
3205: wsh_delivery_details wdd
3206: WHERE wdd.source_header_id = l_header_id
3207: AND wdd.source_line_id = p_order_line_id
3208: AND wdd.source_code = 'OE'
3209: AND wdd.delivery_detail_id = wsn.delivery_detail_id

Line 3212: FROM wsh_delivery_details wdd

3208: AND wdd.source_code = 'OE'
3209: AND wdd.delivery_detail_id = wsn.delivery_detail_id
3210: UNION ALL
3211: SELECT wdd.serial_number serial_number
3212: FROM wsh_delivery_details wdd
3213: WHERE wdd.source_header_id = l_header_id
3214: AND wdd.source_line_id = p_order_line_id
3215: AND wdd.source_code = 'OE'
3216: UNION ALL

Line 3218: FROM wsh_delivery_details wdd,

3214: AND wdd.source_line_id = p_order_line_id
3215: AND wdd.source_code = 'OE'
3216: UNION ALL
3217: SELECT msnt.fm_serial_number
3218: FROM wsh_delivery_details wdd,
3219: mtl_serial_numbers_temp msnt
3220: WHERE wdd.source_header_id = l_header_id
3221: AND wdd.source_line_id = p_order_line_id
3222: AND wdd.source_code = 'OE'