APPS.BOM_CSTRACCR_XMLP_PKG dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 2467: CST_COST_GROUP_ASSIGNMENTS CCGA,

2463: SELECT /*+ ORDERED */ -- Added for perf bug rgangara */
2464: DISTINCT
2465: POH.ORG_ID
2466: FROM
2467: CST_COST_GROUP_ASSIGNMENTS CCGA,
2468: RCV_TRANSACTIONS RT,
2469: PO_HEADERS_ALL POH
2470: WHERE POH.PO_HEADER_ID = RT.PO_HEADER_ID
2471: AND CCGA.ORGANIZATION_ID = RT.ORGANIZATION_ID

Line 2480: CST_COST_GROUP_ASSIGNMENTS CGA

2476: MP.ORGANIZATION_ID,
2477: MP.MASTER_ORGANIZATION_ID
2478: FROM
2479: MTL_PARAMETERS MP,
2480: CST_COST_GROUP_ASSIGNMENTS CGA
2481: WHERE MP.ORGANIZATION_ID = CGA.ORGANIZATION_ID
2482: AND CGA.COST_GROUP_ID = P_COST_GROUP;
2483: BEGIN
2484: SQL_STMT_NUM := '4: ';

Line 2587: CST_COST_GROUP_ASSIGNMENTS

2583: SELECT
2584: count(*)
2585: INTO L_COUNT
2586: FROM
2587: CST_COST_GROUP_ASSIGNMENTS
2588: WHERE COST_GROUP_ID = P_COST_GROUP
2589: AND ORGANIZATION_ID = P_MASTER_ORG_ID;
2590: IF L_COUNT <> 0 THEN
2591: INSERT_AP_MISC;