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_PAC_LOW_LEVEL_CODES

Line 1843: FROM cst_pac_low_level_codes cpllc

1839: )
1840: )
1841: )
1842: AND NOT EXISTS (SELECT 'X'
1843: FROM cst_pac_low_level_codes cpllc
1844: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
1845: AND cpllc.pac_period_id = c_pac_period_id
1846: AND cpllc.cost_group_id = c_cost_group_id)
1847: UNION ALL

Line 1882: FROM cst_pac_low_level_codes cpllc

1878: AND c1.cost_group_id = c2.cost_group_id
1879: AND c1.cost_group_id = c_cost_group_id))
1880: )
1881: AND NOT EXISTS (SELECT 'X'
1882: FROM cst_pac_low_level_codes cpllc
1883: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
1884: AND cpllc.pac_period_id = c_pac_period_id
1885: AND cpllc.cost_group_id = c_cost_group_id)
1886: UNION ALL

Line 1918: FROM cst_pac_low_level_codes cpllc

1914: OR (transaction_action_id in (1,27)
1915: AND transaction_source_type_id NOT IN (1,3,6,13)) )
1916: AND NOT EXISTS (
1917: SELECT 'X'
1918: FROM cst_pac_low_level_codes cpllc
1919: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
1920: AND cpllc.pac_period_id = c_pac_period_id
1921: AND cpllc.cost_group_id = c_cost_group_id);
1922:

Line 2032: FROM cst_pac_low_level_codes cpllc

2028: )
2029: )
2030: )
2031: AND EXISTS (SELECT 'X'
2032: FROM cst_pac_low_level_codes cpllc
2033: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2034: AND cpllc.pac_period_id = c_pac_period_id
2035: AND cpllc.cost_group_id = c_cost_group_id)
2036: UNION ALL

Line 2071: FROM cst_pac_low_level_codes cpllc

2067: AND c1.cost_group_id = c2.cost_group_id
2068: AND c1.cost_group_id = c_cost_group_id))
2069: )
2070: AND EXISTS (SELECT 'X'
2071: FROM cst_pac_low_level_codes cpllc
2072: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2073: AND cpllc.pac_period_id = c_pac_period_id
2074: AND cpllc.cost_group_id = c_cost_group_id)
2075: UNION ALL

Line 2115: FROM cst_pac_low_level_codes cpllc

2111: WHERE we.wip_entity_id = mmt.transaction_source_id
2112: AND we.primary_item_id = mmt.inventory_item_id)) )
2113: AND EXISTS (
2114: SELECT 'X'
2115: FROM cst_pac_low_level_codes cpllc
2116: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2117: AND cpllc.pac_period_id = c_pac_period_id
2118: AND cpllc.cost_group_id = c_cost_group_id);
2119:

Line 2135: FROM cst_pac_low_level_codes

2131: )
2132: IS
2133: SELECT
2134: low_level_code
2135: FROM cst_pac_low_level_codes
2136: WHERE pac_period_id = c_pac_period_id
2137: AND cost_group_id = c_cost_group_id
2138: AND inventory_item_id = c_inventory_item_id;
2139:

Line 2595: FROM cst_pac_low_level_codes

2591: )
2592: IS
2593: SELECT
2594: low_level_code
2595: FROM cst_pac_low_level_codes
2596: WHERE pac_period_id = c_pac_period_id
2597: AND cost_group_id = c_cost_group_id
2598: AND inventory_item_id = c_inventory_item_id;
2599:

Line 2797: FROM cst_pac_low_level_codes cpllc

2793: AND ccg.legal_entity = p_legal_entity_id
2794: AND ccga.organization_id = mmt.organization_id
2795: AND ccga.cost_group_id = ccg.cost_group_id
2796: AND NOT EXISTS (SELECT /*+ no_unnest*/ 'X'
2797: FROM cst_pac_low_level_codes cpllc
2798: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2799: AND cpllc.pac_period_id = p_period_id)
2800: UNION ALL
2801: SELECT mmt.inventory_item_id inventory_item_id

Line 2815: FROM cst_pac_low_level_codes cpllc

2811: AND cpp.pac_period_id = p_period_id
2812: AND mmt.primary_quantity = 0
2813: AND NOT EXISTS (
2814: SELECT /*+ no_unnest*/ 'X'
2815: FROM cst_pac_low_level_codes cpllc
2816: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2817: AND cpllc.pac_period_id = p_period_id)
2818: UNION ALL
2819: SELECT /*+ ORDERED INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/

Line 2849: FROM cst_pac_low_level_codes cpllc

2845: AND ccga.cost_group_id = ccg.cost_group_id
2846: AND ( MIP.from_organization_id = ccga.organization_id
2847: OR MIP.to_organization_id = ccga.organization_id )
2848: AND NOT EXISTS (SELECT /*+ no_unnest*/ 'X'
2849: FROM cst_pac_low_level_codes cpllc
2850: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2851: AND cpllc.pac_period_id = p_period_id)
2852: );
2853:

Line 2862: FROM cst_pac_low_level_codes

2858: SELECT min(low_level_code) top_most_bom_level_code
2859: , count(low_level_code) low_level_count
2860: INTO l_topmost_bom_level_code
2861: ,l_low_level_count
2862: FROM cst_pac_low_level_codes
2863: WHERE pac_period_id = p_period_id;
2864:
2865: IF l_low_level_count = 0 THEN
2866: -- Completion Items not exist

Line 2892: FROM cst_pac_low_level_codes cpllc

2888: p_period_id
2889: ,cpllc.inventory_item_id
2890: ,min(low_level_code) bom_highest_level_code
2891: ,'N'
2892: FROM cst_pac_low_level_codes cpllc
2893: WHERE pac_period_id = p_period_id
2894: GROUP BY inventory_item_id;
2895:
2896: END IF; -- check for any completion item

Line 3613: FROM cst_pac_low_level_codes

3609: ,c_inventory_item_id NUMBER
3610: )
3611: IS
3612: SELECT low_level_code
3613: FROM cst_pac_low_level_codes
3614: WHERE pac_period_id = c_pac_period_id
3615: AND inventory_item_id = c_inventory_item_id
3616: AND rownum = 1;
3617:

Line 3626: FROM cst_pac_low_level_codes

3622: )
3623: IS
3624: SELECT
3625: low_level_code
3626: FROM cst_pac_low_level_codes
3627: WHERE pac_period_id = c_pac_period_id
3628: AND cost_group_id = c_cost_group_id
3629: AND inventory_item_id = c_inventory_item_id;
3630: