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_PAC_ITERATION_PROCESS_PVT dependencies on CST_PAC_LOW_LEVEL_CODES

Line 1332: FROM cst_pac_low_level_codes cpllc

1328: AND mpacd.cost_group_id = p_cost_group_id
1329: AND mpacd.pac_period_id = p_pac_period_id
1330: AND mpacd.inventory_item_id = p_inventory_item_id
1331: AND NOT EXISTS (SELECT 1
1332: FROM cst_pac_low_level_codes cpllc
1333: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
1334: AND cpllc.pac_period_id = p_pac_period_id
1335: AND cpllc.cost_group_id = p_cost_group_id);
1336: ELSE

Line 1353: FROM cst_pac_low_level_codes cpllc

1349: AND mpacd.cost_group_id = p_cost_group_id
1350: AND mpacd.pac_period_id = p_pac_period_id
1351: AND mpacd.inventory_item_id = p_inventory_item_id
1352: AND EXISTS (SELECT 1
1353: FROM cst_pac_low_level_codes cpllc
1354: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
1355: AND cpllc.low_level_code = p_low_level_code
1356: AND cpllc.pac_period_id = p_pac_period_id
1357: AND cpllc.cost_group_id = p_cost_group_id);

Line 1478: FROM cst_pac_low_level_codes cpllc

1474: AND cppb.cost_element_id = cpicd.cost_element_id
1475: AND cppb.level_type = cpicd.level_type
1476: AND cppb.inventory_item_id = p_inventory_item_id)
1477: AND NOT EXISTS (SELECT 1
1478: FROM cst_pac_low_level_codes cpllc
1479: WHERE cpllc.pac_period_id = p_pac_period_id
1480: AND cpllc.cost_group_id = p_cost_group_id
1481: AND cpllc.inventory_item_id = p_inventory_item_id);
1482:

Line 1556: FROM cst_pac_low_level_codes cpllc

1552: AND cppb.cost_group_id = p_cost_group_id
1553: AND cppb.cost_layer_id = cpic.cost_layer_id
1554: AND cppb.inventory_item_id = p_inventory_item_id)
1555: AND NOT EXISTS (SELECT 1
1556: FROM cst_pac_low_level_codes cpllc
1557: WHERE cpllc.inventory_item_id = cpic.inventory_item_id
1558: AND cpllc.pac_period_id = p_pac_period_id
1559: AND cpllc.cost_group_id = p_cost_group_id)
1560: AND EXISTS

Line 1637: FROM cst_pac_low_level_codes cpllc

1633: AND cppb.cost_element_id = cpicd.cost_element_id
1634: AND cppb.level_type = cpicd.level_type
1635: AND cppb.inventory_item_id = p_inventory_item_id)
1636: AND EXISTS (SELECT 1
1637: FROM cst_pac_low_level_codes cpllc
1638: WHERE cpllc.low_level_code = p_low_level_code
1639: AND cpllc.pac_period_id = p_pac_period_id
1640: AND cpllc.cost_group_id = p_cost_group_id
1641: );

Line 1716: FROM cst_pac_low_level_codes cpllc

1712: AND cppb.cost_group_id = p_cost_group_id
1713: AND cppb.cost_layer_id = cpic.cost_layer_id
1714: AND cppb.inventory_item_id = p_inventory_item_id)
1715: AND EXISTS (SELECT 1
1716: FROM cst_pac_low_level_codes cpllc
1717: WHERE cpllc.low_level_code = p_low_level_code
1718: AND cpllc.inventory_item_id = cpic.inventory_item_id
1719: AND cpllc.pac_period_id = p_pac_period_id
1720: AND cpllc.cost_group_id = p_cost_group_id)

Line 1784: FROM cst_pac_low_level_codes

1780: )
1781: IS
1782: SELECT
1783: low_level_code
1784: FROM cst_pac_low_level_codes
1785: WHERE pac_period_id = c_pac_period_id
1786: AND cost_group_id = c_cost_group_id
1787: AND inventory_item_id = c_inventory_item_id;
1788:

Line 3478: cst_pac_low_level_codes cpllc

3474: AND mp.process_enabled_flag = 'N'
3475: AND NOT EXISTS (
3476: SELECT 'X'
3477: FROM
3478: cst_pac_low_level_codes cpllc
3479: WHERE cpllc.inventory_item_id = ccit.inventory_item_id
3480: AND cpllc.pac_period_id = p_period_id
3481: AND cpllc.cost_group_id = p_cost_group_id);
3482:

Line 3526: FROM cst_pac_low_level_codes cpllc

3522: AND cpiit.pac_period_id = p_period_id
3523: AND cpiit.inventory_item_id = ccit.inventory_item_id)
3524: AND NOT EXISTS (
3525: SELECT 'X'
3526: FROM cst_pac_low_level_codes cpllc
3527: WHERE cpllc.inventory_item_id = ccit.inventory_item_id
3528: AND cpllc.pac_period_id = p_period_id
3529: AND cpllc.cost_group_id = p_cost_group_id);
3530:

Line 3561: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc

3557: , 0
3558: , 0
3559: , 'N'
3560: , 'Y'
3561: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc
3562: WHERE ccit.cost_group_id = p_cost_group_id
3563: AND ccit.pac_period_id = p_period_id
3564: AND ccit.txn_type = 1
3565: AND mp.organization_id = ccit.transfer_organization_id

Line 3600: FROM CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_low_level_codes cpllc

3596: , 'N'
3597: , 'N'
3598: , 'Y'
3599: , 1
3600: FROM CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_low_level_codes cpllc
3601: WHERE ccit.cost_group_id = p_cost_group_id
3602: AND ccit.pac_period_id = p_period_id
3603: AND ccit.txn_type = 2
3604: AND cpllc.inventory_item_id = ccit.inventory_item_id

Line 5785: FROM cst_pac_low_level_codes

5781:
5782: CURSOR c_low_level_code_cur(c_pac_period_id NUMBER, c_cost_group_id NUMBER, c_inventory_item_id NUMBER )
5783: IS
5784: SELECT low_level_code
5785: FROM cst_pac_low_level_codes
5786: WHERE pac_period_id = c_pac_period_id
5787: AND cost_group_id = c_cost_group_id
5788: AND inventory_item_id = c_inventory_item_id
5789: AND rownum = 1;