APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on MTL_PARAMETERS

Line 1052: FROM mtl_parameters mp

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

Line 1767: from mtl_parameters mp

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

Line 1779: from mtl_parameters mp2

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

Line 1864: from mtl_parameters mp

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

Line 1956: from mtl_parameters mp

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

Line 1968: from mtl_parameters mp2

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

Line 2053: from mtl_parameters mp

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