eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 1058: FROM cst_cost_group_assignments ccga

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
1059: WHERE ccga.cost_group_id = p_cost_group_id)
1060: AND rownum = 1;
1061:
1062: IF l_count = 0

Line 1248: FROM cst_cost_group_assignments ccga

1244: END IF;
1245:
1246: SELECT count(1)
1247: INTO l_num_of_assignments
1248: FROM cst_cost_group_assignments ccga
1249: WHERE ccga.cost_group_id = p_cost_group_id;
1250:
1251: IF l_num_of_assignments = 0 THEN
1252:

Line 1774: FROM cst_cost_group_assignments ccga

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'
1774: FROM cst_cost_group_assignments ccga
1775: WHERE ccga.cost_group_id = c_cost_group_id
1776: AND (ccga.organization_id = mmt.organization_id OR
1777: ccga.organization_id = mmt.transfer_organization_id))
1778: AND (

Line 1803: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

1799: AND hoi2.org_information_context = 'Accounting Information')))
1800: )
1801: AND (transaction_action_id IN (3,12,21)
1802: AND NOT EXISTS (SELECT 'X'
1803: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
1804: WHERE c1.organization_id = mmt.organization_id
1805: AND c2.organization_id = mmt.transfer_organization_id
1806: AND c1.cost_group_id = c2.cost_group_id)
1807: AND (

Line 1810: FROM cst_cost_group_assignments ccga1

1806: AND c1.cost_group_id = c2.cost_group_id)
1807: AND (
1808: (mmt.transaction_action_id = 3
1809: AND EXISTS (SELECT 'X'
1810: FROM cst_cost_group_assignments ccga1
1811: WHERE ccga1.cost_group_id = c_cost_group_id
1812: AND ccga1.organization_id = mmt.organization_id
1813: AND mmt.primary_quantity < 0)
1814: )

Line 1817: FROM cst_cost_group_assignments ccga2

1813: AND mmt.primary_quantity < 0)
1814: )
1815: OR (mmt.transaction_action_id = 21
1816: AND EXISTS (SELECT 'X'
1817: FROM cst_cost_group_assignments ccga2
1818: WHERE ccga2.organization_id = mmt.organization_id
1819: AND ccga2.cost_group_id = c_cost_group_id)
1820: )
1821: OR (mmt.transaction_action_id = 12

Line 1829: FROM cst_cost_group_assignments ccga2

1825: AND mip.to_organization_id = mmt.organization_id
1826: AND (
1827: (NVL(mmt.fob_point,mip.fob_point) = 1
1828: AND EXISTS (SELECT 'X'
1829: FROM cst_cost_group_assignments ccga2
1830: WHERE ccga2.organization_id = mip.to_organization_id
1831: AND ccga2.cost_group_id = c_cost_group_id)
1832: )
1833: OR (NVL(mmt.fob_point,mip.fob_point) = 2

Line 1835: FROM cst_cost_group_assignments ccga3

1831: AND ccga2.cost_group_id = c_cost_group_id)
1832: )
1833: OR (NVL(mmt.fob_point,mip.fob_point) = 2
1834: AND EXISTS (SELECT 'X'
1835: FROM cst_cost_group_assignments ccga3
1836: WHERE ccga3.organization_id = mip.from_organization_id
1837: AND ccga3.cost_group_id = c_cost_group_id)
1838: )
1839: )

Line 1872: FROM cst_cost_group_assignments ccga0

1868: AND nvl(mp.process_enabled_flag, 'N') = 'N')
1869: AND (
1870: (mmt.transaction_action_id = 22
1871: AND EXISTS ( SELECT 'X'
1872: FROM cst_cost_group_assignments ccga0
1873: WHERE ccga0.organization_id = mmt.organization_id
1874: AND ccga0.cost_group_id = c_cost_group_id))
1875: OR ( (mmt.transaction_action_id IN (12,21) OR (mmt.transaction_action_id = 3 AND mmt.primary_quantity < 0))
1876: AND EXISTS (SELECT 'X'

Line 1877: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

1873: WHERE ccga0.organization_id = mmt.organization_id
1874: AND ccga0.cost_group_id = c_cost_group_id))
1875: OR ( (mmt.transaction_action_id IN (12,21) OR (mmt.transaction_action_id = 3 AND mmt.primary_quantity < 0))
1876: AND EXISTS (SELECT 'X'
1877: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
1878: WHERE c1.organization_id = mmt.organization_id
1879: AND c2.organization_id = mmt.transfer_organization_id
1880: AND c1.cost_group_id = c2.cost_group_id
1881: AND c1.cost_group_id = c_cost_group_id))

Line 1901: , cst_cost_group_assignments ccga

1897: , mmt.subinventory_code
1898: , nvl(mmt.transfer_price,0) transfer_price
1899: FROM
1900: mtl_material_transactions mmt
1901: , cst_cost_group_assignments ccga
1902: WHERE transaction_date between c_period_start_date AND c_period_end_date
1903: AND transaction_action_id in (4,8,28,33,34,1,2,5,27)
1904: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
1905: AND mmt.inventory_item_id = c_inventory_item_id

Line 1963: FROM cst_cost_group_assignments ccga

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'
1963: FROM cst_cost_group_assignments ccga
1964: WHERE ccga.cost_group_id = c_cost_group_id
1965: AND (ccga.organization_id = mmt.organization_id OR
1966: ccga.organization_id = mmt.transfer_organization_id))
1967: AND (

Line 1992: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

1988: AND hoi2.org_information_context = 'Accounting Information')))
1989: )
1990: AND (transaction_action_id IN (3,12,21)
1991: AND NOT EXISTS (SELECT 'X'
1992: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
1993: WHERE c1.organization_id = mmt.organization_id
1994: AND c2.organization_id = mmt.transfer_organization_id
1995: AND c1.cost_group_id = c2.cost_group_id)
1996: AND (

Line 1999: FROM cst_cost_group_assignments ccga1

1995: AND c1.cost_group_id = c2.cost_group_id)
1996: AND (
1997: (mmt.transaction_action_id = 3
1998: AND EXISTS (SELECT 'X'
1999: FROM cst_cost_group_assignments ccga1
2000: WHERE ccga1.cost_group_id = c_cost_group_id
2001: AND ccga1.organization_id = mmt.organization_id
2002: AND mmt.primary_quantity < 0)
2003: )

Line 2006: FROM cst_cost_group_assignments ccga2

2002: AND mmt.primary_quantity < 0)
2003: )
2004: OR (mmt.transaction_action_id = 21
2005: AND EXISTS (SELECT 'X'
2006: FROM cst_cost_group_assignments ccga2
2007: WHERE ccga2.organization_id = mmt.organization_id
2008: AND ccga2.cost_group_id = c_cost_group_id)
2009: )
2010: OR (mmt.transaction_action_id = 12

Line 2018: FROM cst_cost_group_assignments ccga2

2014: AND mip.to_organization_id = mmt.organization_id
2015: AND (
2016: (NVL(mmt.fob_point,mip.fob_point) = 1
2017: AND EXISTS (SELECT 'X'
2018: FROM cst_cost_group_assignments ccga2
2019: WHERE ccga2.organization_id = mip.to_organization_id
2020: AND ccga2.cost_group_id = c_cost_group_id)
2021: )
2022: OR (NVL(mmt.fob_point,mip.fob_point) = 2

Line 2024: FROM cst_cost_group_assignments ccga3

2020: AND ccga2.cost_group_id = c_cost_group_id)
2021: )
2022: OR (NVL(mmt.fob_point,mip.fob_point) = 2
2023: AND EXISTS (SELECT 'X'
2024: FROM cst_cost_group_assignments ccga3
2025: WHERE ccga3.organization_id = mip.from_organization_id
2026: AND ccga3.cost_group_id = c_cost_group_id)
2027: )
2028: )

Line 2061: FROM cst_cost_group_assignments ccga0

2057: AND nvl(mp.process_enabled_flag, 'N') = 'N')
2058: AND (
2059: (mmt.transaction_action_id = 22
2060: AND EXISTS ( SELECT 'X'
2061: FROM cst_cost_group_assignments ccga0
2062: WHERE ccga0.organization_id = mmt.organization_id
2063: AND ccga0.cost_group_id = c_cost_group_id))
2064: OR ( (mmt.transaction_action_id IN (12,21) OR (mmt.transaction_action_id = 3 AND mmt.primary_quantity < 0))
2065: AND EXISTS (SELECT 'X'

Line 2066: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

2062: WHERE ccga0.organization_id = mmt.organization_id
2063: AND ccga0.cost_group_id = c_cost_group_id))
2064: OR ( (mmt.transaction_action_id IN (12,21) OR (mmt.transaction_action_id = 3 AND mmt.primary_quantity < 0))
2065: AND EXISTS (SELECT 'X'
2066: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
2067: WHERE c1.organization_id = mmt.organization_id
2068: AND c2.organization_id = mmt.transfer_organization_id
2069: AND c1.cost_group_id = c2.cost_group_id
2070: AND c1.cost_group_id = c_cost_group_id))

Line 2090: , cst_cost_group_assignments ccga

2086: , mmt.subinventory_code
2087: , nvl(mmt.transfer_price,0) transfer_price
2088: FROM
2089: mtl_material_transactions mmt
2090: , cst_cost_group_assignments ccga
2091: WHERE transaction_date between c_period_start_date AND c_period_end_date
2092: AND transaction_action_id in (4,8,28,33,34,1,2,5,27)
2093: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2094: AND mmt.inventory_item_id = c_inventory_item_id

Line 2787: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga

2783: distinct(mmt.inventory_item_id)
2784: ,p_period_id
2785: ,1000
2786: ,'N'
2787: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga
2788: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2789: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2790: AND nvl(mmt.owning_tp_type,2) = 2
2791: AND ccg.legal_entity = p_legal_entity_id

Line 4168: , cst_cost_group_assignments ccga

4164: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
4165: , mmt.subinventory_code
4166: FROM
4167: mtl_material_transactions mmt
4168: , cst_cost_group_assignments ccga
4169: WHERE mmt.transaction_date BETWEEN c_start_date AND c_end_date
4170: AND ccga.organization_id = mmt.organization_id
4171: AND ccga.cost_group_id = c_cost_group_id
4172: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)