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.CSTPPPSC dependencies on CST_LE_COST_TYPES

Line 518: FROM CST_LE_COST_TYPES

514: SELECT NVL(CREATE_ACCT_ENTRIES,'N')
515: , nvl(transfer_cost_flag,'N')
516: INTO distributions_flag
517: , transfer_cost_flag
518: FROM CST_LE_COST_TYPES
519: WHERE LEGAL_ENTITY = l_entity_id
520: AND COST_TYPE_ID = l_cost_type_id
521: AND PRIMARY_COST_METHOD > 2;
522:

Line 577: from gl_sets_of_books gsob, cst_le_cost_types clct

573: WHERE gp.period_name = open_period_name
574: AND gp.period_num = open_period_num
575: AND gp.period_year = open_period_year
576: AND gp.period_set_name = (select gsob.period_set_name
577: from gl_sets_of_books gsob, cst_le_cost_types clct
578: where gsob.set_of_books_id = clct.set_of_books_id
579: and clct.legal_entity = l_entity_id
580: and clct.cost_type_id = l_cost_type_id
581: and clct.primary_cost_method > 2)

Line 962: FROM CST_LE_COST_TYPES

958: AND cppp.process_upto_date IS NOT NULL)
959: OR
960: ( cppp.process_phase = 6
961: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
962: FROM CST_LE_COST_TYPES
963: WHERE LEGAL_ENTITY = l_entity_id
964: AND COST_TYPE_ID = l_cost_type_id
965: AND PRIMARY_COST_METHOD > 2
966: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1004: FROM CST_LE_COST_TYPES

1000: AND cppp.process_upto_date IS NOT NULL)
1001: OR
1002: ( cppp.process_phase = 6
1003: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1004: FROM CST_LE_COST_TYPES
1005: WHERE LEGAL_ENTITY = l_entity_id
1006: AND COST_TYPE_ID = l_cost_type_id
1007: AND PRIMARY_COST_METHOD > 2
1008: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1047: FROM CST_LE_COST_TYPES

1043: AND cppp.process_upto_date IS NOT NULL)
1044: OR
1045: ( cppp.process_phase = 6
1046: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1047: FROM CST_LE_COST_TYPES
1048: WHERE LEGAL_ENTITY = l_entity_id
1049: AND COST_TYPE_ID = l_cost_type_id
1050: AND PRIMARY_COST_METHOD > 2
1051: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1089: FROM CST_LE_COST_TYPES

1085: AND cppp.process_upto_date IS NOT NULL)
1086: OR
1087: ( cppp.process_phase = 6
1088: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1089: FROM CST_LE_COST_TYPES
1090: WHERE LEGAL_ENTITY = l_entity_id
1091: AND COST_TYPE_ID = l_cost_type_id
1092: AND PRIMARY_COST_METHOD > 2
1093: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1132: FROM CST_LE_COST_TYPES

1128: AND cppp.process_upto_date IS NOT NULL)
1129: OR
1130: ( cppp.process_phase = 6
1131: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1132: FROM CST_LE_COST_TYPES
1133: WHERE LEGAL_ENTITY = l_entity_id
1134: AND COST_TYPE_ID = l_cost_type_id
1135: AND PRIMARY_COST_METHOD > 2
1136: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1429: FROM CST_LE_COST_TYPES

1425: OR
1426: ( process_status <> 4
1427: AND process_phase = 6
1428: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1429: FROM CST_LE_COST_TYPES
1430: WHERE LEGAL_ENTITY = l_entity_id
1431: AND COST_TYPE_ID = l_cost_type_id
1432: AND PRIMARY_COST_METHOD > 2
1433: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1454: FROM CST_LE_COST_TYPES

1450: OR
1451: ( process_status <> 4
1452: AND process_phase = 6
1453: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1454: FROM CST_LE_COST_TYPES
1455: WHERE LEGAL_ENTITY = l_entity_id
1456: AND COST_TYPE_ID = l_cost_type_id
1457: AND PRIMARY_COST_METHOD > 2
1458: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1490: FROM CST_LE_COST_TYPES

1486: OR
1487: ( process_date < trunc(closing_end_date)+1
1488: AND process_phase = 6
1489: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1490: FROM CST_LE_COST_TYPES
1491: WHERE LEGAL_ENTITY = l_entity_id
1492: AND COST_TYPE_ID = l_cost_type_id
1493: AND PRIMARY_COST_METHOD > 2
1494: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1504: FROM CST_LE_COST_TYPES

1500: OR
1501: ( trunc(NVL(process_upto_date,closing_end_date-1)) < trunc(closing_end_date)
1502: AND process_phase = 6
1503: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1504: FROM CST_LE_COST_TYPES
1505: WHERE LEGAL_ENTITY = l_entity_id
1506: AND COST_TYPE_ID = l_cost_type_id
1507: AND PRIMARY_COST_METHOD > 2
1508: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1698: -- bug 9648974 fix: only get the create_acct_entries flag from cst_le_cost_types

1694:
1695: <>
1696: /* ********** Perform validations for Revenue / COGS Matching *********** */
1697: l_stmt_num := 60;
1698: -- bug 9648974 fix: only get the create_acct_entries flag from cst_le_cost_types
1699: -- for the legal entity/cost type combination. The ledger_id associated to the
1700: -- legal entity/cost type combination should be obtained from the perpetual side.
1701: SELECT distinct --clct.set_of_books_id,
1702: nvl(clct.create_acct_entries,'N')

Line 1705: FROM cst_le_cost_types clct

1701: SELECT distinct --clct.set_of_books_id,
1702: nvl(clct.create_acct_entries,'N')
1703: INTO --l_ledger_id,
1704: l_create_acct_entries
1705: FROM cst_le_cost_types clct
1706: WHERE clct.cost_type_id = l_cost_type_id
1707: AND clct.legal_entity = l_entity_id;
1708:
1709: l_stmt_num := 61;

Line 2255: FROM CST_LE_COST_TYPES

2251:
2252: l_stmt_num := 20;
2253: SELECT NVL(CREATE_ACCT_ENTRIES,'N')
2254: INTO distributions_flag
2255: FROM CST_LE_COST_TYPES
2256: WHERE LEGAL_ENTITY = l_entity_id
2257: AND COST_TYPE_ID = l_cost_type_id
2258: AND PRIMARY_COST_METHOD > 2;
2259: