APPS.BOM_CSTRACCR_XMLP_PKG dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 2462: CST_COST_GROUP_ASSIGNMENTS CCGA,

2458: SELECT /*+ ORDERED */ -- Added for perf bug rgangara */
2459: DISTINCT
2460: POH.ORG_ID
2461: FROM
2462: CST_COST_GROUP_ASSIGNMENTS CCGA,
2463: RCV_TRANSACTIONS RT,
2464: PO_HEADERS_ALL POH
2465: WHERE POH.PO_HEADER_ID = RT.PO_HEADER_ID
2466: AND CCGA.ORGANIZATION_ID = RT.ORGANIZATION_ID

Line 2475: CST_COST_GROUP_ASSIGNMENTS CGA

2471: MP.ORGANIZATION_ID,
2472: MP.MASTER_ORGANIZATION_ID
2473: FROM
2474: MTL_PARAMETERS MP,
2475: CST_COST_GROUP_ASSIGNMENTS CGA
2476: WHERE MP.ORGANIZATION_ID = CGA.ORGANIZATION_ID
2477: AND CGA.COST_GROUP_ID = P_COST_GROUP;
2478: BEGIN
2479: SQL_STMT_NUM := '4: ';

Line 2582: CST_COST_GROUP_ASSIGNMENTS

2578: SELECT
2579: count(*)
2580: INTO L_COUNT
2581: FROM
2582: CST_COST_GROUP_ASSIGNMENTS
2583: WHERE COST_GROUP_ID = P_COST_GROUP
2584: AND ORGANIZATION_ID = P_MASTER_ORG_ID;
2585: IF L_COUNT <> 0 THEN
2586: INSERT_AP_MISC;