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_DETAILS

Line 92: FROM wsh_delivery_details wdd, csd_product_transactions cpt,mtl_material_transactions mmt

88: WHERE cpt.delivery_detail_id = mmt.picking_line_id
89: AND cpt.product_transaction_id = p_product_txn_id
90: UNION ALL
91: SELECT mmt.transaction_id
92: FROM wsh_delivery_details wdd, csd_product_transactions cpt,mtl_material_transactions mmt
93: WHERE cpt.delivery_detail_id = wdd.split_from_delivery_detail_id
94: AND cpt.order_header_id = wdd.source_header_id
95: AND wdd.source_code = 'OE'
96: AND cpt.product_transaction_id = p_product_txn_id

Line 286: FROM wsh_delivery_details wdd,

282: wsn.to_serial_number
283: BULK COLLECT INTO
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

Line 946: wsh_delivery_details wdd

942: wdd.delivery_detail_id
943: FROM oe_order_headers_all ooh,
944: oe_order_lines_all ool,
945: po_requisition_lines_all pol,
946: wsh_delivery_details wdd
947: WHERE ooh.orig_sys_document_ref = x_requisition_number
948: AND ooh.source_document_id = x_requisition_id
949: AND ooh.header_id = ool.header_id
950: AND pol.requisition_header_id = x_requisition_id

Line 1110: FROM wsh_delivery_details wdd,

1106:
1107: -- check if the line is back ordered.
1108: SELECT wdd.released_status,wdd.picked_quantity,wdd.delivery_detail_id,NVL(cpt.quantity_available,cpt.exp_quantity)
1109: INTO l_dummy,l_picked_quantity,l_delivery_detail_id,l_requested_quantity
1110: FROM wsh_delivery_details wdd,
1111: csd_product_transactions cpt
1112: WHERE cpt.product_transaction_id = p_product_txn_id
1113: AND cpt.delivery_detail_id = wdd.delivery_detail_id;
1114:

Line 1120: FROM wsh_delivery_details wdd

1116: THEN
1117: BEGIN
1118: SELECT delivery_detail_id,picked_quantity
1119: INTO l_delivery_detail_id_new,l_picked_quantity
1120: FROM wsh_delivery_details wdd
1121: WHERE wdd.split_from_delivery_detail_id = l_delivery_detail_id
1122: AND released_status = 'Y';
1123:
1124: UPDATE csd_product_transactions SET delivery_detail_id = l_delivery_detail_id_new,quantity_picked = l_picked_quantity

Line 1169: FROM wsh_delivery_details wdd

1165: THEN
1166: BEGIN
1167: SELECT delivery_detail_id
1168: INTO l_delivery_detail_id_new
1169: FROM wsh_delivery_details wdd
1170: WHERE wdd.split_from_delivery_detail_id = l_delivery_detail_id
1171: AND released_status = 'B';
1172:
1173: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 1299: changed_attributes wsh_delivery_details_pub.changedattributetabtype;

1295: l_order_rec csd_process_pvt.om_interface_rec;
1296: l_prod_txn_rec csd_process_pvt.product_txn_rec;
1297: l_counter NUMBER := 0;
1298: source_code VARCHAR2(15) := 'OE';
1299: changed_attributes wsh_delivery_details_pub.changedattributetabtype;
1300: l_serial_num_range_tab wsh_glbl_var_strct_grp.ddserialrangetabtype;
1301: l_attribs_changed_flag BOOLEAN := FALSE;
1302: p_delivery_id NUMBER;
1303: p_action_code VARCHAR2(15);

Line 1429: wsh_delivery_details wdd,

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
1433: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1442: wsh_delivery_details wdd,

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
1446: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1499: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Calling WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes');

1495: changed_attributes(1).lot_number := p_lot_num;
1496: END IF;
1497:
1498: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1499: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Calling WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes');
1500: END IF;
1501:
1502: IF l_attribs_changed_flag
1503: THEN

Line 1504: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(

1500: END IF;
1501:
1502: IF l_attribs_changed_flag
1503: THEN
1504: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(
1505: p_api_version_number => 1.0,
1506: p_init_msg_list => p_init_msg_list,
1507: p_commit => p_commit,
1508: x_return_status => x_return_status,

Line 1542: from wsh_delivery_details

1538:
1539: --bug#14632475 --bug#14644674
1540: select organization_id
1541: into l_delivery_org_id
1542: from wsh_delivery_details
1543: where delivery_detail_id = l_delivery_detail_id;
1544:
1545: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1546: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'organization_id = '||l_delivery_org_id);

Line 1615: FROM wsh_delivery_details wdd

1611: --debug(lc_api_name,'Ship confirm failed');
1612: BEGIN
1613: SELECT 'N'
1614: INTO l_shipped_flag
1615: FROM wsh_delivery_details wdd
1616: WHERE wdd.delivery_detail_id = l_delivery_detail_id
1617: AND wdd.released_status <> 'C';
1618: EXCEPTION
1619: WHEN no_data_found THEN

Line 1638: FROM wsh_delivery_details

1634: END IF;
1635:
1636: SELECT shipped_quantity
1637: INTO l_quantity_shipped
1638: FROM wsh_delivery_details
1639: WHERE delivery_detail_id = l_delivery_detail_id;
1640:
1641: UPDATE csd_product_transactions SET quantity_shipped =
1642: (l_quantity_shipped + nvl(quantity_shipped,0) )

Line 1843: FROM wsh_delivery_details wdd, csd_product_transactions cpt,mtl_material_transactions mmt

1839: WHERE cpt.delivery_detail_id = mmt.picking_line_id
1840: AND cpt.product_transaction_id = p_product_txn_id
1841: UNION ALL
1842: SELECT mmt.transaction_id
1843: FROM wsh_delivery_details wdd, csd_product_transactions cpt,mtl_material_transactions mmt
1844: WHERE cpt.delivery_detail_id = wdd.split_from_delivery_detail_id
1845: AND cpt.order_header_id = wdd.source_header_id
1846: AND wdd.source_code = 'OE'
1847: AND cpt.product_transaction_id = p_product_txn_id

Line 2068: FROM wsh_delivery_details wdd,csd_product_transactions cpt

2064: SAVEPOINT RELEASE_SALESORDER;
2065: -- get the delivery line status.
2066: SELECT wdd.released_status,wdd.requested_quantity,wdd.requested_quantity_uom,wdd.delivery_detail_id
2067: INTO l_delivery_status,l_requested_qty,l_transaction_uom,l_delivery_detail_id
2068: FROM wsh_delivery_details wdd,csd_product_transactions cpt
2069: WHERE wdd.delivery_detail_id = cpt.delivery_detail_id
2070: AND product_transaction_id = p_product_txn_id
2071: AND wdd.source_code = 'OE';
2072:

Line 2235: FROM wsh_delivery_details wdd,

2231: SELECT mtrh.header_id,mmtt.transaction_temp_id,
2232: mtrl.line_id,wdd.delivery_detail_id
2233: INTO l_move_order_hdr_id,l_mmtt_temp_id,
2234: l_move_order_line_id,G_DELIVERY_DETAIL_ID
2235: FROM wsh_delivery_details wdd,
2236: mtl_txn_request_headers mtrh,
2237: mtl_txn_request_lines mtrl,
2238: mtl_material_transactions_temp mmtt,
2239: csd_product_transactions cpt

Line 2263: FROM wsh_delivery_details wdd,

2259: -- we would need to create the allocation here. We make use of inv_replenish_detail_pub.line_details
2260: -- to create the allocations.
2261: SELECT wdd.move_order_line_id
2262: INTO l_move_order_line_id
2263: FROM wsh_delivery_details wdd,
2264: csd_product_transactions cpt
2265: WHERE wdd.delivery_detail_id = cpt.delivery_detail_id
2266: AND cpt.product_transaction_id = p_product_txn_id;
2267:

Line 2518: FROM wsh_delivery_details

2514: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Checking if the delivery is successfully pick released. DDID='||l_delivery_detail_id);
2515: END IF;
2516: SELECT released_status,delivery_detail_id,picked_quantity
2517: INTO l_delivery_status,l_delivery_detail_id_new,l_picked_qty
2518: FROM wsh_delivery_details
2519: WHERE move_order_line_id = l_move_order_line_id;
2520:
2521: IF l_delivery_status <> 'Y'
2522: THEN