DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on MTL_TXN_REQUEST_LINES_S

Line 1232: mtl_txn_request_lines_s.NEXTVAL -- LINE_ID

1228: ,OPERATION_SEQ_NUM
1229: ,WIP_SUPPLY_TYPE
1230: )
1231: (SELECT
1232: mtl_txn_request_lines_s.NEXTVAL -- LINE_ID
1233: ,HEADER_ID
1234: ,mtrl_max.line_num --LINE_NUMBER
1235: ,ORGANIZATION_ID
1236: ,INVENTORY_ITEM_ID

Line 1373: UPDATE mtl_txn_request_lines SET

1369: END IF;
1370:
1371: -- Update the quantity on the original MOL record.
1372: BEGIN
1373: UPDATE mtl_txn_request_lines SET
1374: quantity = l_mol_qty - l_atd_qty,
1375: primary_quantity = l_mol_prim_qty - l_atd_prim_qty,
1376: secondary_quantity = l_mol_qty2 - l_atd_mol_qty2
1377: WHERE line_id = l_mol_line_id;

Line 1416: UPDATE mtl_txn_request_lines SET

1412: -- {{
1413: -- Test for MOL qty = available to detail qty. MOL record should be
1414: -- crossdocked properly. }}11
1415: BEGIN
1416: UPDATE mtl_txn_request_lines SET
1417: backorder_delivery_detail_id = l_backorder_detail_id,
1418: crossdock_type = l_crossdock_type,
1419: wip_entity_id = l_wip_entity_id,
1420: repetitive_schedule_id = l_repetitive_schedule_id,