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 1845: FROM cst_pac_low_level_codes cpllc

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

Line 1884: FROM cst_pac_low_level_codes cpllc

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

Line 1920: FROM cst_pac_low_level_codes cpllc

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

Line 2034: FROM cst_pac_low_level_codes cpllc

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

Line 2073: FROM cst_pac_low_level_codes cpllc

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

Line 2117: FROM cst_pac_low_level_codes cpllc

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

Line 2137: FROM cst_pac_low_level_codes

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

Line 2597: FROM cst_pac_low_level_codes

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

Line 2795: FROM cst_pac_low_level_codes cpllc

2791: AND ccg.legal_entity = p_legal_entity_id
2792: AND ccga.organization_id = mmt.organization_id
2793: AND ccga.cost_group_id = ccg.cost_group_id
2794: AND NOT EXISTS (SELECT /*+ no_unnest*/ 'X'
2795: FROM cst_pac_low_level_codes cpllc
2796: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2797: AND cpllc.pac_period_id = p_period_id);
2798:
2799: -- initialize lower bom level code

Line 2807: FROM cst_pac_low_level_codes

2803: SELECT min(low_level_code) top_most_bom_level_code
2804: , count(low_level_code) low_level_count
2805: INTO l_topmost_bom_level_code
2806: ,l_low_level_count
2807: FROM cst_pac_low_level_codes
2808: WHERE pac_period_id = p_period_id;
2809:
2810: IF l_low_level_count = 0 THEN
2811: -- Completion Items not exist

Line 2837: FROM cst_pac_low_level_codes cpllc

2833: p_period_id
2834: ,cpllc.inventory_item_id
2835: ,min(low_level_code) bom_highest_level_code
2836: ,'N'
2837: FROM cst_pac_low_level_codes cpllc
2838: WHERE pac_period_id = p_period_id
2839: GROUP BY inventory_item_id;
2840:
2841: END IF; -- check for any completion item

Line 3475: FROM cst_pac_low_level_codes

3471: ,c_inventory_item_id NUMBER
3472: )
3473: IS
3474: SELECT low_level_code
3475: FROM cst_pac_low_level_codes
3476: WHERE pac_period_id = c_pac_period_id
3477: AND inventory_item_id = c_inventory_item_id
3478: AND rownum = 1;
3479:

Line 3488: FROM cst_pac_low_level_codes

3484: )
3485: IS
3486: SELECT
3487: low_level_code
3488: FROM cst_pac_low_level_codes
3489: WHERE pac_period_id = c_pac_period_id
3490: AND cost_group_id = c_cost_group_id
3491: AND inventory_item_id = c_inventory_item_id;
3492: