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 1056: FROM cst_cost_group_assignments ccga

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

Line 1246: FROM cst_cost_group_assignments ccga

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

Line 1772: FROM cst_cost_group_assignments ccga

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

Line 1801: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

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

Line 1808: FROM cst_cost_group_assignments ccga1

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

Line 1815: FROM cst_cost_group_assignments ccga2

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

Line 1827: FROM cst_cost_group_assignments ccga2

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

Line 1833: FROM cst_cost_group_assignments ccga3

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

Line 1870: FROM cst_cost_group_assignments ccga0

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

Line 1875: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

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

Line 1899: , cst_cost_group_assignments ccga

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

Line 1961: FROM cst_cost_group_assignments ccga

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

Line 1990: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

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

Line 1997: FROM cst_cost_group_assignments ccga1

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

Line 2004: FROM cst_cost_group_assignments ccga2

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

Line 2016: FROM cst_cost_group_assignments ccga2

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

Line 2022: FROM cst_cost_group_assignments ccga3

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

Line 2059: FROM cst_cost_group_assignments ccga0

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

Line 2064: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

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

Line 2088: , cst_cost_group_assignments ccga

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

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

2785: FROM
2786: (
2787: SELECT /*+ leading (MMT) INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/
2788: mmt.inventory_item_id inventory_item_id
2789: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga
2790: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2791: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2792: AND nvl(mmt.owning_tp_type,2) = 2
2793: AND ccg.legal_entity = p_legal_entity_id

Line 2822: cst_cost_group_assignments ccga,

2818: UNION ALL
2819: SELECT /*+ ORDERED INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/
2820: mmt.inventory_item_id inventory_item_id
2821: FROM cst_cost_groups ccg,
2822: cst_cost_group_assignments ccga,
2823: mtl_interorg_parameters mip,
2824: mtl_material_transactions mmt
2825: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2826: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 4537: , cst_cost_group_assignments ccga

4533: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
4534: , mmt.subinventory_code
4535: FROM
4536: mtl_material_transactions mmt
4537: , cst_cost_group_assignments ccga
4538: WHERE mmt.transaction_date BETWEEN c_start_date AND c_end_date
4539: AND ccga.organization_id = mmt.organization_id
4540: AND ccga.cost_group_id = c_cost_group_id
4541: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)