APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 1064: FROM mtl_txn_request_lines mtrl,

1060:
1061: BEGIN
1062: SELECT SUM((mtrl.quantity - (Nvl(mtrl.quantity_detailed,0) +
1063: Nvl(mtrl.quantity_delivered,0)))) INTO l_open_mo_qty
1064: FROM mtl_txn_request_lines mtrl,
1065: Mtl_txn_request_headers mtrh
1066: WHERE mtrl.header_id = mtrh.header_id
1067: AND mtrl.organization_id = mtrh.organization_id
1068: AND mtrl.organization_id = L_ORG_ID

Line 2728: FROM mtl_txn_request_lines

2724: , from_locator_id
2725: INTO l_create_qty
2726: , l_mo_source_sub
2727: , l_mo_source_loc
2728: FROM mtl_txn_request_lines
2729: WHERE line_id = p_move_order_line_id
2730: AND organization_id = p_organization_id
2731: AND inventory_item_id = p_inventory_item_id;
2732: IF (l_debug = 1) THEN

Line 4272: UPDATE mtl_txn_request_lines mtrl

4268: -- NOTE: l_quantity_detailed contains all qty of MMTT related TO CURRENT mo line whether in this
4269: -- RUN OR ANY previous runs
4270: IF l_quantity_detailed < (l_x_trolin_tbl(1).quantity - Nvl(l_x_trolin_tbl(1).quantity_delivered,0)) THEN -- partial allocation
4271: -- update the quantity detailed correctly
4272: UPDATE mtl_txn_request_lines mtrl
4273: SET mtrl.quantity_detailed = l_quantity_detailed
4274: where line_id = l_x_trolin_tbl(1).line_id;
4275:
4276: IF (l_debug = 1) THEN

Line 4283: UPDATE mtl_txn_request_lines mtrl

4279:
4280: ELSE -- Fully allocated
4281: -- it has been completely detailed
4282: -- do not close the MO, otherwise pick Drop of repl task fails
4283: UPDATE mtl_txn_request_lines mtrl
4284: SET mtrl.quantity_detailed = l_quantity_detailed
4285: where line_id = l_x_trolin_tbl(1).line_id;
4286:
4287: IF (l_debug = 1) THEN

Line 4567: from mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

4563: -- well AS untouched move ORDER qty
4564: (mtrl.QUANTITY - NVL(mtrl.QUANTITY_DELIVERED,0)) AS quantity,
4565: mtrl.uom_code,
4566: Nvl(mtrl.quantity_detailed,0) AS quantity_detailed
4567: from mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
4568: where mtrl.header_id = mtrh.header_id
4569: and mtrl.organization_id = P_ORG_ID
4570: and mtrl.inventory_item_id = p_item_id
4571: and mtrl.to_subinventory_code = P_FP_SUB

Line 4594: mtl_txn_request_lines mtrl,

4590:
4591: mtrl.uom_code,
4592: Nvl(mtrl.quantity_detailed,0) AS quantity_detailed
4593: FROM
4594: mtl_txn_request_lines mtrl,
4595: (
4596: SELECT WRD.Source_line_id, WRD.source_header_id,
4597: wrd.inventory_item_id, SUM(wrd.Primary_quantity) quantity,
4598: wrd.organization_id,wrd.primary_uom

Line 7137: FROM mtl_txn_request_lines mtrl,

7133: Nvl(mtrl.quantity_delivered,0) mol_delivered_qty,
7134: mtrl.uom_code,
7135: mtrl.header_id,
7136: mtrl.line_id
7137: FROM mtl_txn_request_lines mtrl,
7138: Mtl_txn_request_headers mtrh
7139: WHERE mtrl.header_id = mtrh.header_id
7140: And mtrl.organization_id = mtrh.organization_id
7141: and mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')

Line 7537: UPDATE mtl_txn_request_lines mtrl

7533: -- NOTE: l_quantity_detailed contains all qty of MMTT related TO CURRENT mo line whether in this
7534: -- RUN OR ANY previous runs
7535: IF l_quantity_detailed < (l_open_repl_mo.mol_qty - l_open_repl_mo.mol_delivered_qty) THEN -- partial allocation
7536: -- update the quantity detailed correctly
7537: UPDATE mtl_txn_request_lines mtrl
7538: SET mtrl.quantity_detailed = l_quantity_detailed
7539: where line_id = l_open_repl_mo.line_id;
7540:
7541: IF (l_debug = 1) THEN

Line 7549: UPDATE mtl_txn_request_lines mtrl

7545: ELSE -- Fully allocated
7546: -- it has been completely detailed
7547: -- DO NOT Close the MO, otherwise finalize Pick
7548: -- Confirm fails WHILE dropping the task
7549: UPDATE mtl_txn_request_lines mtrl
7550: SET mtrl.quantity_detailed = l_quantity_detailed
7551: where line_id = l_open_repl_mo.line_id;
7552:
7553: IF (l_debug = 1) THEN