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 = wmti.organization_code) --Fix by bug 9220479
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 = NVL(wmti.organization_code,
133: mp.organization_code)--Fix by bug 9220479
134: AND mp.organization_id = wmti.organization_id
135: )

Line 1637: mtl_parameters mp,

1633: mp.negative_inv_receipt_code negative_allow,
1634: msik.concatenated_segments assembly_name
1635: FROM wip_discrete_jobs wdj,
1636: mtl_system_items_kfv msik,
1637: mtl_parameters mp,
1638: wip_move_txn_interface wmti
1639: WHERE wdj.primary_item_id = msik.inventory_item_id
1640: AND wdj.organization_id = msik.organization_id
1641: AND wdj.organization_id = mp.organization_id

Line 1685: mtl_parameters mp,

1681: msik.concatenated_segments assembly_name
1682: FROM wip_repetitive_schedules wrs,
1683: wip_repetitive_items wri,
1684: mtl_system_items_kfv msik,
1685: mtl_parameters mp,
1686: wip_move_txn_interface wmti
1687: WHERE wmti.primary_item_id = msik.inventory_item_id
1688: AND wmti.organization_id = msik.organization_id
1689: AND wmti.organization_id = mp.organization_id