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_INTERNAL_ORDERS_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 288: wsh_delivery_assignments wda

284: l_fm_serial_num_tbl,
285: l_to_serial_num_tbl
286: FROM wsh_delivery_details wdd,
287: wsh_serial_numbers wsn,
288: wsh_delivery_assignments wda
289: WHERE wda.delivery_id = to_number(l_shipment_num(i))
290: AND wda.delivery_detail_id = wdd.delivery_detail_id
291: AND wdd.source_code = 'OE'
292: AND wdd.delivery_detail_id = wsn.delivery_detail_id;

Line 1428: FROM wsh_delivery_assignments wda,

1424:
1425: BEGIN
1426: SELECT wdd.delivery_detail_id,wda.delivery_id
1427: INTO l_delivery_detail_id,p_delivery_id
1428: FROM wsh_delivery_assignments wda,
1429: wsh_delivery_details wdd,
1430: csd_product_transactions cpt
1431: WHERE cpt.product_transaction_id = p_product_txn_id
1432: AND wdd.delivery_detail_id = cpt.delivery_detail_id

Line 1441: FROM wsh_delivery_assignments wda,

1437: -- the order was possibly split.
1438: -- assumption. We assume that at any point, we will have one open delivery line.
1439: SELECT wdd.delivery_detail_id,wda.delivery_id
1440: INTO l_delivery_detail_id,p_delivery_id
1441: FROM wsh_delivery_assignments wda,
1442: wsh_delivery_details wdd,
1443: csd_product_transactions cpt
1444: WHERE cpt.product_transaction_id = p_product_txn_id
1445: AND wdd.split_from_delivery_detail_id = cpt.delivery_detail_id