APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 1047: FROM mtl_txn_request_lines mtrl,

1043:
1044: BEGIN
1045: SELECT SUM((mtrl.quantity - (Nvl(mtrl.quantity_detailed,0) +
1046: Nvl(mtrl.quantity_delivered,0)))) INTO l_open_mo_qty
1047: FROM mtl_txn_request_lines mtrl,
1048: Mtl_txn_request_headers mtrh
1049: WHERE mtrl.header_id = mtrh.header_id
1050: AND mtrl.organization_id = mtrh.organization_id
1051: AND mtrl.organization_id = L_ORG_ID

Line 2659: FROM mtl_txn_request_lines

2655: , from_locator_id
2656: INTO l_create_qty
2657: , l_mo_source_sub
2658: , l_mo_source_loc
2659: FROM mtl_txn_request_lines
2660: WHERE line_id = p_move_order_line_id
2661: AND organization_id = p_organization_id
2662: AND inventory_item_id = p_inventory_item_id;
2663: IF (l_debug = 1) THEN

Line 4152: UPDATE mtl_txn_request_lines mtrl

4148: -- NOTE: l_quantity_detailed contains all qty of MMTT related TO CURRENT mo line whether in this
4149: -- RUN OR ANY previous runs
4150: IF l_quantity_detailed < (l_x_trolin_tbl(1).quantity - Nvl(l_x_trolin_tbl(1).quantity_delivered,0)) THEN -- partial allocation
4151: -- update the quantity detailed correctly
4152: UPDATE mtl_txn_request_lines mtrl
4153: SET mtrl.quantity_detailed = l_quantity_detailed
4154: where line_id = l_x_trolin_tbl(1).line_id;
4155:
4156: IF (l_debug = 1) THEN

Line 4163: UPDATE mtl_txn_request_lines mtrl

4159:
4160: ELSE -- Fully allocated
4161: -- it has been completely detailed
4162: -- do not close the MO, otherwise pick Drop of repl task fails
4163: UPDATE mtl_txn_request_lines mtrl
4164: SET mtrl.quantity_detailed = l_quantity_detailed
4165: where line_id = l_x_trolin_tbl(1).line_id;
4166:
4167: IF (l_debug = 1) THEN

Line 4425: from mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

4421: -- well AS untouched move ORDER qty
4422: (mtrl.QUANTITY - NVL(mtrl.QUANTITY_DELIVERED,0)) AS quantity,
4423: mtrl.uom_code,
4424: Nvl(mtrl.quantity_detailed,0) AS quantity_detailed
4425: from mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
4426: where mtrl.header_id = mtrh.header_id
4427: and mtrl.organization_id = P_ORG_ID
4428: and mtrl.inventory_item_id = p_item_id
4429: and mtrl.to_subinventory_code = P_FP_SUB

Line 4452: mtl_txn_request_lines mtrl,

4448:
4449: mtrl.uom_code,
4450: Nvl(mtrl.quantity_detailed,0) AS quantity_detailed
4451: FROM
4452: mtl_txn_request_lines mtrl,
4453: (
4454: SELECT WRD.Source_line_id, WRD.source_header_id,
4455: wrd.inventory_item_id, SUM(wrd.Primary_quantity) quantity,
4456: wrd.organization_id,wrd.primary_uom

Line 6962: FROM mtl_txn_request_lines mtrl,

6958: Nvl(mtrl.quantity_delivered,0) mol_delivered_qty,
6959: mtrl.uom_code,
6960: mtrl.header_id,
6961: mtrl.line_id
6962: FROM mtl_txn_request_lines mtrl,
6963: Mtl_txn_request_headers mtrh
6964: WHERE mtrl.header_id = mtrh.header_id
6965: And mtrl.organization_id = mtrh.organization_id
6966: and mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')

Line 7362: UPDATE mtl_txn_request_lines mtrl

7358: -- NOTE: l_quantity_detailed contains all qty of MMTT related TO CURRENT mo line whether in this
7359: -- RUN OR ANY previous runs
7360: IF l_quantity_detailed < (l_open_repl_mo.mol_qty - l_open_repl_mo.mol_delivered_qty) THEN -- partial allocation
7361: -- update the quantity detailed correctly
7362: UPDATE mtl_txn_request_lines mtrl
7363: SET mtrl.quantity_detailed = l_quantity_detailed
7364: where line_id = l_open_repl_mo.line_id;
7365:
7366: IF (l_debug = 1) THEN

Line 7374: UPDATE mtl_txn_request_lines mtrl

7370: ELSE -- Fully allocated
7371: -- it has been completely detailed
7372: -- DO NOT Close the MO, otherwise finalize Pick
7373: -- Confirm fails WHILE dropping the task
7374: UPDATE mtl_txn_request_lines mtrl
7375: SET mtrl.quantity_detailed = l_quantity_detailed
7376: where line_id = l_open_repl_mo.line_id;
7377:
7378: IF (l_debug = 1) THEN