APPS.INV_COPY_ORGANIZATION_REPORT dependencies on CST_COST_TYPES

Line 3658: , CST_COST_TYPES cct1

3654: )
3655: IS
3656: SELECT br1.RESOURCE_CODE, cct1.COST_TYPE
3657: FROM CST_RESOURCE_COSTS crc1
3658: , CST_COST_TYPES cct1
3659: , BOM_RESOURCES br1
3660: WHERE crc1.ORGANIZATION_ID = p_model_org_id
3661: AND br1.RESOURCE_ID = crc1.RESOURCE_ID
3662: AND cct1.COST_TYPE_ID = crc1.COST_TYPE_ID

Line 3665: , CST_COST_TYPES cct2

3661: AND br1.RESOURCE_ID = crc1.RESOURCE_ID
3662: AND cct1.COST_TYPE_ID = crc1.COST_TYPE_ID
3663: AND NOT EXISTS ( SELECT 'x'
3664: FROM CST_RESOURCE_COSTS crc2
3665: , CST_COST_TYPES cct2
3666: , BOM_RESOURCES br2
3667: WHERE crc2.ORGANIZATION_ID = p_organization_id
3668: AND br2.RESOURCE_ID = crc2.RESOURCE_ID
3669: AND br2.RESOURCE_CODE = br1.RESOURCE_CODE

Line 3757: , CST_COST_TYPES cct1

3753: SELECT br1.RESOURCE_CODE
3754: , cct1.COST_TYPE
3755: , br2.RESOURCE_CODE
3756: FROM CST_RESOURCE_OVERHEADS crh1
3757: , CST_COST_TYPES cct1
3758: , BOM_RESOURCES br1
3759: , BOM_RESOURCES br2
3760: WHERE crh1.ORGANIZATION_ID = p_model_org_id
3761: AND br1.RESOURCE_ID = crh1.RESOURCE_ID

Line 3766: , CST_COST_TYPES cct2

3762: AND br2.RESOURCE_ID = crh1.OVERHEAD_ID
3763: AND cct1.COST_TYPE_ID = crh1.COST_TYPE_ID
3764: AND NOT EXISTS ( SELECT 'x'
3765: FROM CST_RESOURCE_OVERHEADS crh2
3766: , CST_COST_TYPES cct2
3767: , BOM_RESOURCES br3
3768: WHERE crh2.ORGANIZATION_ID = p_organization_id
3769: AND br3.RESOURCE_ID = crh2.RESOURCE_ID
3770: AND br3.RESOURCE_CODE = br1.RESOURCE_CODE