APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on MTL_PARAMETERS

Line 1054: FROM mtl_parameters mp

1050: -- master org being validated.
1051:
1052: SELECT count(1)
1053: INTO l_count
1054: FROM mtl_parameters mp
1055: WHERE mp.master_organization_id <> l_master_org_id
1056: AND mp.organization_id IN (
1057: SELECT organization_id
1058: FROM cst_cost_group_assignments ccga

Line 1769: from mtl_parameters mp

1765: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
1766: AND mmt.inventory_item_id = c_inventory_item_id
1767: AND nvl(mmt.owning_tp_type,2) = 2
1768: AND EXISTS (select 'X'
1769: from mtl_parameters mp
1770: where mmt.organization_id = mp.organization_id
1771: AND nvl(mp.process_enabled_flag, 'N') = 'N')
1772: AND transaction_action_id in (3,12,21)
1773: AND EXISTS (SELECT 'EXISTS'

Line 1781: from mtl_parameters mp2

1777: ccga.organization_id = mmt.transfer_organization_id))
1778: AND (
1779: (mmt.transaction_source_type_id = 13
1780: AND EXISTS (select 'X'
1781: from mtl_parameters mp2
1782: where mp2.organization_id = mmt.transfer_organization_id
1783: AND mp2.process_enabled_flag = 'Y'))
1784: OR (mmt.transaction_source_type_id in (7,8)
1785: AND EXISTS (SELECT 'X'

Line 1866: from mtl_parameters mp

1862: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
1863: AND mmt.inventory_item_id = c_inventory_item_id
1864: AND nvl(mmt.owning_tp_type,2) = 2
1865: AND EXISTS (select 'X'
1866: from mtl_parameters mp
1867: where mmt.organization_id = mp.organization_id
1868: AND nvl(mp.process_enabled_flag, 'N') = 'N')
1869: AND (
1870: (mmt.transaction_action_id = 22

Line 1958: from mtl_parameters mp

1954: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
1955: AND mmt.inventory_item_id = c_inventory_item_id
1956: AND nvl(mmt.owning_tp_type,2) = 2
1957: AND EXISTS (select 'X'
1958: from mtl_parameters mp
1959: where mmt.organization_id = mp.organization_id
1960: AND nvl(mp.process_enabled_flag, 'N') = 'N')
1961: AND transaction_action_id in (3,12,21)
1962: AND EXISTS (SELECT 'EXISTS'

Line 1970: from mtl_parameters mp2

1966: ccga.organization_id = mmt.transfer_organization_id))
1967: AND (
1968: (mmt.transaction_source_type_id = 13
1969: AND EXISTS (select 'X'
1970: from mtl_parameters mp2
1971: where mp2.organization_id = mmt.transfer_organization_id
1972: AND mp2.process_enabled_flag = 'Y'))
1973: OR (mmt.transaction_source_type_id in (7,8)
1974: AND EXISTS (SELECT 'X'

Line 2055: from mtl_parameters mp

2051: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2052: AND mmt.inventory_item_id = c_inventory_item_id
2053: AND nvl(mmt.owning_tp_type,2) = 2
2054: AND EXISTS (select 'X'
2055: from mtl_parameters mp
2056: where mmt.organization_id = mp.organization_id
2057: AND nvl(mp.process_enabled_flag, 'N') = 'N')
2058: AND (
2059: (mmt.transaction_action_id = 22