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.

[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on CSD_PRODUCT_TRANSACTIONS

Line 63: FROM mtl_system_items_b msi, mtl_item_sub_defaults mis,csd_product_transactions cpt

59: msi.inventory_item_id,mis.subinventory_code,cpt.rcv_into_org,cpt.rcv_into_ou,
60: msi.primary_unit_of_measure
61: INTO l_serial_control_flag,l_lot_control_flag,l_primary_uom,
62: l_inventory_item_id,l_subinventory,l_to_org_id,l_destn_ou,l_uom
63: FROM mtl_system_items_b msi, mtl_item_sub_defaults mis,csd_product_transactions cpt
64: WHERE cpt.product_transaction_id = p_product_txn_id
65: AND cpt.rcv_into_org = msi.organization_id
66: AND cpt.inventory_item_id = msi.inventory_item_id
67: AND msi.organization_id = mis.organization_id(+)

Line 74: FROM csd_product_transactions cpt, po_requisition_lines_all prl

70: -- 1. Get the requisition line id and from org information.
71: SELECT cpt.ship_from_org,prl.requisition_line_id,prl.deliver_to_location_id,
72: NVL(p_receiving_subinv,l_subinventory)
73: INTO l_from_org,l_requisition_line_id,l_deliver_to_location_id,l_subinventory
74: FROM csd_product_transactions cpt, po_requisition_lines_all prl
75: WHERE cpt.product_transaction_id = p_product_txn_id
76: AND cpt.req_header_id = prl.requisition_header_id
77: AND NVL(cpt.req_line_id,prl.requisition_line_id) = prl.requisition_line_id;
78:

Line 87: FROM csd_product_transactions cpt,mtl_material_transactions mmt

83: WHERE rsl.requisition_line_id = l_requisition_line_id
84: AND rsh.shipment_header_id = rsl.shipment_header_id
85: AND nvl(rsl.quantity_received,0) = 0
86: AND rsl.mmt_transaction_id IN (SELECT mmt.transaction_id
87: FROM 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

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 100: FROM csd_product_transactions cpt1

96: AND cpt.product_transaction_id = p_product_txn_id
97: AND wdd.delivery_detail_id = mmt.picking_line_id
98: AND NOT EXISTS(
99: SELECT 'exists'
100: FROM csd_product_transactions cpt1
101: WHERE wdd.delivery_detail_id = cpt1.delivery_detail_id
102: AND cpt.order_header_id = cpt1.order_header_id
103: )
104: );

Line 338: INSERT INTO csd_product_transactions

334: BEGIN
335:
336: IF action = 'PICK'
337: THEN
338: INSERT INTO csd_product_transactions
339: (product_transaction_id,
340: repair_line_id,
341: req_header_id,
342: order_header_id,

Line 360: SELECT csd_product_transactions_s1.nextval,

356: delivery_detail_id,
357: object_version_number,
358: req_line_id
359: )
360: SELECT csd_product_transactions_s1.nextval,
361: repair_line_id,
362: req_header_id,
363: order_header_id,
364: order_line_id,

Line 380: FROM csd_product_transactions

376: (NVL(quantity_available,exp_quantity) - quantity_picked) available_quantity,
377: p_delivery_detail_id,
378: to_number('1'),
379: req_line_id
380: FROM csd_product_transactions
381: WHERE order_header_id = p_order_header_id
382: AND delivery_detail_id = p_delivery_detail_id_new;
383:
384: UPDATE csd_product_transactions SET quantity_available = 0

Line 384: UPDATE csd_product_transactions SET quantity_available = 0

380: FROM csd_product_transactions
381: WHERE order_header_id = p_order_header_id
382: AND delivery_detail_id = p_delivery_detail_id_new;
383:
384: UPDATE csd_product_transactions SET quantity_available = 0
385: WHERE delivery_detail_id = p_delivery_detail_id_new;
386:
387: END IF;
388: END handle_partial_action;

Line 597: FROM csd_product_transactions cpt,mtl_system_items_b msi

593: l_material_accounts.EXTEND;
594: BEGIN
595: SELECT NVL(p_quantitys(i),cpt.exp_quantity),cpt.inventory_item_id,msi.description,msi.primary_uom_code
596: INTO l_quantitys(i),l_inventory_item_ids(i),l_item_descriptions(i),l_uom_codes(i)
597: FROM csd_product_transactions cpt,mtl_system_items_b msi
598: WHERE cpt.product_transaction_id = p_product_txn_ids(i)
599: AND cpt.inventory_item_id = msi.inventory_item_id
600: AND msi.organization_id = p_destination_orgs(i);
601: EXCEPTION

Line 792: -- update the csd_product_transactions.

788:
789: BEGIN
790:
791: -- create internal requisition.
792: -- update the csd_product_transactions.
793: -- Create Internal Order po program.
794: -- order import program.
795: -- update csd_product_transactions.
796:

Line 795: -- update csd_product_transactions.

791: -- create internal requisition.
792: -- update the csd_product_transactions.
793: -- Create Internal Order po program.
794: -- order import program.
795: -- update csd_product_transactions.
796:
797: -- Step 1. Create internal requisition.
798: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
799: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling CSD_INTERNAL_ORDERS_PVT.create_internal_requisition');

Line 869: -- update the csd_product_transactions.

865: l_current_ou NUMBER := fnd_global.org_id;
866:
867: BEGIN
868: -- create internal requisition.
869: -- update the csd_product_transactions.
870: -- Create Internal Order po program.
871: -- order import program.
872: -- update csd_product_transactions.
873:

Line 872: -- update csd_product_transactions.

868: -- create internal requisition.
869: -- update the csd_product_transactions.
870: -- Create Internal Order po program.
871: -- order import program.
872: -- update csd_product_transactions.
873:
874: -- Step 1. Create internal requisition.
875: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
876: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling CSD_INTERNAL_ORDERS_PVT.create_internal_requisition');

Line 909: UPDATE csd_product_transactions SET req_header_id = x_requisition_id

905:
906: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
907: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Requisition created.Update prod txn tbl with req id='||x_requisition_id);
908: END IF;
909: UPDATE csd_product_transactions SET req_header_id = x_requisition_id
910: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(p_product_txn_ids AS JTF_NUMBER_TABLE)));
911:
912: -- Step 3. Launch the Create Internal Orders program.
913: -- the code is factored and the create sales orders CP programs have been grouped together to avoid

Line 933: -- Step 6. Get the ISO order header id and line id and update csd_product_transactions.

929: retcode := 2;
930: RETURN;
931: END IF;
932:
933: -- Step 6. Get the ISO order header id and line id and update csd_product_transactions.
934: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
935: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting ISO created and updating prod txn tbl.');
936: END IF;
937:

Line 957: UPDATE csd_product_transactions SET req_line_id = i.requisition_line_id,order_header_id = i.header_id,

953: AND wdd.source_line_id = ool.line_id
954: AND wdd.source_code = 'OE'
955: )
956: LOOP
957: UPDATE csd_product_transactions SET req_line_id = i.requisition_line_id,order_header_id = i.header_id,
958: order_line_id = i.line_id,delivery_detail_id = i.delivery_detail_id
959: WHERE req_header_id = x_requisition_id
960: AND inventory_item_id = i.inventory_item_id;
961: END LOOP;

Line 1111: csd_product_transactions cpt

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:
1115: IF l_picked_quantity IS NULL

Line 1124: UPDATE csd_product_transactions SET delivery_detail_id = l_delivery_detail_id_new,quantity_picked = 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
1125: WHERE order_header_id = p_order_header_id
1126: AND delivery_detail_id = l_delivery_detail_id;
1127:
1128: handle_partial_action

Line 1135: UPDATE csd_product_transactions SET quantity_available = 0

1131: p_delivery_detail_id => l_delivery_detail_id,
1132: p_delivery_detail_id_new => l_delivery_detail_id_new
1133: );
1134:
1135: UPDATE csd_product_transactions SET quantity_available = 0
1136: WHERE order_header_id = p_order_header_id
1137: AND delivery_detail_id = l_delivery_detail_id;
1138: EXCEPTION
1139: WHEN no_data_found THEN

Line 1177: UPDATE csd_product_transactions SET quantity_picked = l_picked_quantity

1173: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1174: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Picking is partial.Splitting the product transaction id by making call to handle_partial_action');
1175: END IF;
1176:
1177: UPDATE csd_product_transactions SET quantity_picked = l_picked_quantity
1178: WHERE order_header_id = p_order_header_id
1179: AND delivery_detail_id = l_delivery_detail_id;
1180:
1181: handle_partial_action

Line 1199: UPDATE csd_product_transactions SET quantity_available = 0, quantity_picked = l_picked_quantity

1195: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1196: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Updating the picked quantity.');
1197: END IF;
1198:
1199: UPDATE csd_product_transactions SET quantity_available = 0, quantity_picked = l_picked_quantity
1200: WHERE order_header_id = p_order_header_id
1201: AND delivery_detail_id = l_delivery_detail_id;
1202:
1203: END IF;

Line 1245: /*UPDATE csd_product_transactions SET release_sales_order_flag = 'Y',

1241: -- update the product transaction record. Mark it as picked.
1242: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1243: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Updating ISO as released.');
1244: END IF;
1245: /*UPDATE csd_product_transactions SET release_sales_order_flag = 'Y',
1246: prod_txn_status = 'RELEASED'
1247: WHERE product_transaction_id = p_product_txn_id;*/
1248: UPDATE csd_product_transactions SET release_sales_order_flag = 'Y',
1249: prod_txn_status = 'RELEASED'

Line 1248: UPDATE csd_product_transactions SET release_sales_order_flag = 'Y',

1244: END IF;
1245: /*UPDATE csd_product_transactions SET release_sales_order_flag = 'Y',
1246: prod_txn_status = 'RELEASED'
1247: WHERE product_transaction_id = p_product_txn_id;*/
1248: UPDATE csd_product_transactions SET release_sales_order_flag = 'Y',
1249: prod_txn_status = 'RELEASED'
1250: WHERE order_header_id = p_order_header_id
1251: AND quantity_picked IS NOT NULL;
1252:

Line 1378: FROM mtl_system_items_kfv msi, csd_product_transactions cpt

1374: INTO l_serial_control_flag,
1375: l_rev_control_flag,
1376: l_lot_control_flag,
1377: l_item_name
1378: FROM mtl_system_items_kfv msi, csd_product_transactions cpt
1379: WHERE cpt.product_transaction_id = p_product_txn_id
1380: AND cpt.inventory_item_id = msi.inventory_item_id
1381: AND msi.organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
1382:

Line 1430: csd_product_transactions cpt

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
1434: AND wdd.released_status = 'Y';

Line 1443: csd_product_transactions cpt

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
1447: AND wdd.released_status = 'Y'

Line 1631: -- update the csd_product_transactions table with the shipped quantity information.

1627: RAISE FND_API.G_EXC_ERROR;
1628: END IF;
1629: END IF;
1630:
1631: -- update the csd_product_transactions table with the shipped quantity information.
1632: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1633: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Updating quantity shipped in prod txn tbl');
1634: END IF;
1635:

Line 1641: UPDATE csd_product_transactions SET quantity_shipped =

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) )
1643: WHERE order_header_id = p_order_header_id
1644: AND delivery_detail_id = (SELECT delivery_detail_id
1645: FROM csd_product_transactions

Line 1645: FROM csd_product_transactions

1641: UPDATE csd_product_transactions SET quantity_shipped =
1642: (l_quantity_shipped + nvl(quantity_shipped,0) )
1643: WHERE order_header_id = p_order_header_id
1644: AND delivery_detail_id = (SELECT delivery_detail_id
1645: FROM csd_product_transactions
1646: WHERE product_transaction_id = p_product_txn_id
1647: ); --p_product_txn_id;
1648:
1649: IF l_del_split_flag

Line 1807: FROM csd_product_transactions

1803: END IF;
1804:
1805: SELECT nvl(quantity_shipped,0),delivery_detail_id
1806: INTO l_dummy,l_delivery_detail_id
1807: FROM csd_product_transactions
1808: WHERE product_transaction_id = p_product_txn_id
1809: AND order_header_id = p_order_header_id
1810: AND order_line_id = p_order_line_id;
1811:

Line 1826: FROM csd_product_transactions cpt,

1822: END IF;
1823: BEGIN
1824: SELECT SUM(rt.quantity)
1825: INTO l_received_quantity
1826: FROM csd_product_transactions cpt,
1827: po_requisition_lines_all prl,
1828: rcv_shipment_headers rsh,
1829: rcv_shipment_lines rsl,
1830: rcv_transactions rt

Line 1838: FROM csd_product_transactions cpt,mtl_material_transactions mmt

1834: AND rsl.shipment_header_id = rsh.shipment_header_id
1835: AND rt.transaction_type = 'RECEIVE'
1836: AND rt.shipment_header_id = rsh.shipment_header_id
1837: AND rsl.mmt_transaction_id IN (SELECT mmt.transaction_id
1838: FROM 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

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 1851: FROM csd_product_transactions cpt1

1847: AND cpt.product_transaction_id = p_product_txn_id
1848: AND wdd.delivery_detail_id = mmt.picking_line_id
1849: AND NOT EXISTS(
1850: SELECT 'exists'
1851: FROM csd_product_transactions cpt1
1852: WHERE wdd.delivery_detail_id = cpt1.delivery_detail_id
1853: AND cpt.order_header_id = cpt1.order_header_id
1854: )
1855: );

Line 1866: UPDATE csd_product_transactions SET quantity_received = l_received_quantity

1862: IF l_received_quantity > 0 then
1863: -- update the received quantity on product transactions.
1864: IF (l_dummy - l_received_quantity) >= 0
1865: THEN
1866: UPDATE csd_product_transactions SET quantity_received = l_received_quantity
1867: WHERE order_header_id = p_order_header_id
1868: AND delivery_detail_id = l_delivery_detail_id; --p_product_txn_id;
1869:
1870: IF fnd_api.to_boolean(p_commit)

Line 1915: -- update the quantity received field in csd_product_transactions with receipt quantity.

1911: END IF;
1912: RAISE fnd_api.g_exc_error;
1913: END IF;
1914:
1915: -- update the quantity received field in csd_product_transactions with receipt quantity.
1916: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1917: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Updating csd_product_transactions.received_quantity');
1918: END IF;
1919:

Line 1917: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Updating csd_product_transactions.received_quantity');

1913: END IF;
1914:
1915: -- update the quantity received field in csd_product_transactions with receipt quantity.
1916: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1917: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Updating csd_product_transactions.received_quantity');
1918: END IF;
1919:
1920: -- find out the transacted quantity from the rcv_transactions.
1921: SELECT SUM(quantity)

Line 1927: UPDATE csd_product_transactions SET quantity_received = (

1923: FROM rcv_transactions
1924: WHERE group_id = x_request_group_id
1925: AND transaction_type = 'RECEIVE';
1926:
1927: UPDATE csd_product_transactions SET quantity_received = (
1928: l_received_quantity + nvl(quantity_received,0))
1929: WHERE order_header_id = p_order_header_id
1930: AND delivery_detail_id = l_delivery_detail_id; --product_transaction_id = p_product_txn_id;
1931:

Line 1933: UPDATE csd_product_transactions cpt

1929: WHERE order_header_id = p_order_header_id
1930: AND delivery_detail_id = l_delivery_detail_id; --product_transaction_id = p_product_txn_id;
1931:
1932: -- update the product transaction status.
1933: UPDATE csd_product_transactions cpt
1934: SET prod_txn_status =
1935: (SELECT 'RECEIVED'
1936: FROM csd_product_transactions
1937: WHERE product_transaction_id = cpt.product_transaction_id

Line 1936: FROM csd_product_transactions

1932: -- update the product transaction status.
1933: UPDATE csd_product_transactions cpt
1934: SET prod_txn_status =
1935: (SELECT 'RECEIVED'
1936: FROM csd_product_transactions
1937: WHERE product_transaction_id = cpt.product_transaction_id
1938: AND NVL(quantity_shipped,0) = exp_quantity
1939: UNION ALL
1940: SELECT 'RECEIVED'

Line 1941: FROM csd_product_transactions

1937: WHERE product_transaction_id = cpt.product_transaction_id
1938: AND NVL(quantity_shipped,0) = exp_quantity
1939: UNION ALL
1940: SELECT 'RECEIVED'
1941: FROM csd_product_transactions
1942: WHERE product_transaction_id = cpt.product_transaction_id
1943: AND NVL(quantity_shipped,0) < exp_quantity
1944: AND quantity_shipped > 0
1945: )

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 2074: UPDATE csd_product_transactions SET quantity_available = l_requested_qty

2070: AND product_transaction_id = p_product_txn_id
2071: AND wdd.source_code = 'OE';
2072:
2073: -- requested quantity is the quantity available for transaction.
2074: UPDATE csd_product_transactions SET quantity_available = l_requested_qty
2075: WHERE delivery_detail_id = l_delivery_detail_id;
2076:
2077: IF NOT (l_delivery_status = 'S' OR l_delivery_status = 'Y') THEN
2078: -- fetch the customer details.

Line 2239: csd_product_transactions cpt

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
2240: WHERE wdd.delivery_detail_id = cpt.delivery_detail_id
2241: AND cpt.product_transaction_id = p_product_txn_id
2242: AND wdd.move_order_line_id = mtrl.line_id
2243: AND mtrl.header_id = mtrh.header_id

Line 2264: csd_product_transactions cpt

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:
2268: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 2531: UPDATE csd_product_transactions SET quantity_picked = l_picked_qty,

2527: IF l_picked_qty IS NOT NULL THEN
2528: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2529: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Updating the picked quantity: Quantity picked = '||l_picked_qty);
2530: END IF;
2531: UPDATE csd_product_transactions SET quantity_picked = l_picked_qty,
2532: delivery_detail_id = l_delivery_detail_id_new
2533: WHERE order_header_id = p_order_header_id
2534: AND delivery_detail_id = l_delivery_detail_id;
2535: END IF;

Line 2544: FROM csd_product_transactions

2540: END IF;
2541: BEGIN
2542: SELECT 'Y'
2543: INTO l_dummy
2544: FROM csd_product_transactions
2545: WHERE order_header_id = p_order_header_id
2546: AND product_transaction_id = p_product_txn_id
2547: AND quantity_picked < quantity_available
2548: AND quantity_picked IS NOT NULL;

Line 2572: UPDATE csd_product_transactions SET quantity_available = 0

2568: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2569: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Successfully picked the available quantity. Updating the quantity available to zero for this line');
2570: END IF;
2571:
2572: UPDATE csd_product_transactions SET quantity_available = 0
2573: WHERE delivery_detail_id = l_delivery_detail_id_new;
2574: END IF;
2575:
2576: IF fnd_api.to_boolean(p_commit)

Line 2626: FROM csd_product_transactions cpt,

2622: BEGIN
2623:
2624: SELECT DISTINCT order_number
2625: BULK COLLECT INTO l_internal_orders_tbl
2626: FROM csd_product_transactions cpt,
2627: oe_order_headers_all oeh
2628: WHERE cpt.repair_line_id = p_repair_line_id
2629: AND cpt.order_header_id = oeh.header_id
2630: AND cpt.action_type IS NULL;