DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MTL_PARAMETERS

Line 111: FROM mtl_parameters mp

107: -- Derive ORGANIZATIOIN_ID if user provided only ORGANIZATION_CODE
108: UPDATE wip_move_txn_interface wmti
109: SET wmti.organization_id =
110: (SELECT mp.organization_id
111: FROM mtl_parameters mp
112: WHERE mp.organization_code = UPPER(wmti.organization_code))
113: WHERE wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
114: AND wmti.process_status = WIP_CONSTANTS.PENDING
115: AND wmti.organization_id IS NULL

Line 131: FROM mtl_parameters mp

127: AND ((wmti.organization_id IS NULL) -- cannot derive ORGANIZATION_ID
128: OR
129: (NOT EXISTS
130: (SELECT 'X'
131: FROM mtl_parameters mp
132: WHERE mp.organization_code = UPPER(NVL(wmti.organization_code,
133: mp.organization_code))
134: AND mp.organization_id = wmti.organization_id
135: )

Line 1569: mtl_parameters mp,

1565: mp.negative_inv_receipt_code negative_allow,
1566: msik.concatenated_segments assembly_name
1567: FROM wip_discrete_jobs wdj,
1568: mtl_system_items_kfv msik,
1569: mtl_parameters mp,
1570: wip_move_txn_interface wmti
1571: WHERE wdj.primary_item_id = msik.inventory_item_id
1572: AND wdj.organization_id = msik.organization_id
1573: AND wdj.organization_id = mp.organization_id

Line 1617: mtl_parameters mp,

1613: msik.concatenated_segments assembly_name
1614: FROM wip_repetitive_schedules wrs,
1615: wip_repetitive_items wri,
1616: mtl_system_items_kfv msik,
1617: mtl_parameters mp,
1618: wip_move_txn_interface wmti
1619: WHERE wmti.primary_item_id = msik.inventory_item_id
1620: AND wmti.organization_id = msik.organization_id
1621: AND wmti.organization_id = mp.organization_id