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 489: FROM CST_LE_COST_TYPES

485: SELECT NVL(CREATE_ACCT_ENTRIES,'N')
486: , nvl(transfer_cost_flag,'N')
487: INTO distributions_flag
488: , transfer_cost_flag
489: FROM CST_LE_COST_TYPES
490: WHERE LEGAL_ENTITY = l_entity_id
491: AND COST_TYPE_ID = l_cost_type_id
492: AND PRIMARY_COST_METHOD > 2;
493:

Line 548: from gl_sets_of_books gsob, cst_le_cost_types clct

544: WHERE gp.period_name = open_period_name
545: AND gp.period_num = open_period_num
546: AND gp.period_year = open_period_year
547: AND gp.period_set_name = (select gsob.period_set_name
548: from gl_sets_of_books gsob, cst_le_cost_types clct
549: where gsob.set_of_books_id = clct.set_of_books_id
550: and clct.legal_entity = l_entity_id
551: and clct.cost_type_id = l_cost_type_id
552: and clct.primary_cost_method > 2)

Line 860: FROM cst_le_cost_types clct

856: WHERE gps.application_id = 200
857: AND gps.closing_status <> 'C'
858: AND trunc(gps.end_date) = trunc(p_closing_end_date)
859: AND gps.set_of_books_id = ( SELECT distinct clct.set_of_books_id
860: FROM cst_le_cost_types clct
861: WHERE clct.cost_type_id = p_cost_type_id
862: AND clct.legal_entity = p_entity_id
863: )
864: AND rownum < 2;

Line 903: FROM CST_LE_COST_TYPES

899: AND cppp.process_upto_date IS NOT NULL)
900: OR
901: ( cppp.process_phase = 6
902: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
903: FROM CST_LE_COST_TYPES
904: WHERE LEGAL_ENTITY = l_entity_id
905: AND COST_TYPE_ID = l_cost_type_id
906: AND PRIMARY_COST_METHOD > 2
907: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 945: FROM CST_LE_COST_TYPES

941: AND cppp.process_upto_date IS NOT NULL)
942: OR
943: ( cppp.process_phase = 6
944: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
945: FROM CST_LE_COST_TYPES
946: WHERE LEGAL_ENTITY = l_entity_id
947: AND COST_TYPE_ID = l_cost_type_id
948: AND PRIMARY_COST_METHOD > 2
949: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 988: FROM CST_LE_COST_TYPES

984: AND cppp.process_upto_date IS NOT NULL)
985: OR
986: ( cppp.process_phase = 6
987: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
988: FROM CST_LE_COST_TYPES
989: WHERE LEGAL_ENTITY = l_entity_id
990: AND COST_TYPE_ID = l_cost_type_id
991: AND PRIMARY_COST_METHOD > 2
992: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1030: FROM CST_LE_COST_TYPES

1026: AND cppp.process_upto_date IS NOT NULL)
1027: OR
1028: ( cppp.process_phase = 6
1029: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1030: FROM CST_LE_COST_TYPES
1031: WHERE LEGAL_ENTITY = l_entity_id
1032: AND COST_TYPE_ID = l_cost_type_id
1033: AND PRIMARY_COST_METHOD > 2
1034: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1073: FROM CST_LE_COST_TYPES

1069: AND cppp.process_upto_date IS NOT NULL)
1070: OR
1071: ( cppp.process_phase = 6
1072: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1073: FROM CST_LE_COST_TYPES
1074: WHERE LEGAL_ENTITY = l_entity_id
1075: AND COST_TYPE_ID = l_cost_type_id
1076: AND PRIMARY_COST_METHOD > 2
1077: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1350: FROM CST_LE_COST_TYPES

1346: OR
1347: ( process_status <> 4
1348: AND process_phase = 6
1349: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1350: FROM CST_LE_COST_TYPES
1351: WHERE LEGAL_ENTITY = l_entity_id
1352: AND COST_TYPE_ID = l_cost_type_id
1353: AND PRIMARY_COST_METHOD > 2
1354: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1375: FROM CST_LE_COST_TYPES

1371: OR
1372: ( process_status <> 4
1373: AND process_phase = 6
1374: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1375: FROM CST_LE_COST_TYPES
1376: WHERE LEGAL_ENTITY = l_entity_id
1377: AND COST_TYPE_ID = l_cost_type_id
1378: AND PRIMARY_COST_METHOD > 2
1379: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1411: FROM CST_LE_COST_TYPES

1407: OR
1408: ( process_date < trunc(closing_end_date)+1
1409: AND process_phase = 6
1410: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1411: FROM CST_LE_COST_TYPES
1412: WHERE LEGAL_ENTITY = l_entity_id
1413: AND COST_TYPE_ID = l_cost_type_id
1414: AND PRIMARY_COST_METHOD > 2
1415: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1425: FROM CST_LE_COST_TYPES

1421: OR
1422: ( trunc(NVL(process_upto_date,closing_end_date-1)) < trunc(closing_end_date)
1423: AND process_phase = 6
1424: AND EXISTS ( SELECT CREATE_ACCT_ENTRIES
1425: FROM CST_LE_COST_TYPES
1426: WHERE LEGAL_ENTITY = l_entity_id
1427: AND COST_TYPE_ID = l_cost_type_id
1428: AND PRIMARY_COST_METHOD > 2
1429: AND NVL(CREATE_ACCT_ENTRIES,'N') = 'Y')

Line 1612: FROM cst_le_cost_types clct

1608: SELECT distinct clct.set_of_books_id,
1609: nvl(clct.create_acct_entries,'N')
1610: INTO l_ledger_id,
1611: l_create_acct_entries
1612: FROM cst_le_cost_types clct
1613: WHERE clct.cost_type_id = l_cost_type_id
1614: AND clct.legal_entity = l_entity_id;
1615:
1616: -- If the create_acct_entries field is not YES for this LE/CT, there is

Line 2052: FROM CST_LE_COST_TYPES

2048:
2049: l_stmt_num := 20;
2050: SELECT NVL(CREATE_ACCT_ENTRIES,'N')
2051: INTO distributions_flag
2052: FROM CST_LE_COST_TYPES
2053: WHERE LEGAL_ENTITY = l_entity_id
2054: AND COST_TYPE_ID = l_cost_type_id
2055: AND PRIMARY_COST_METHOD > 2;
2056: