APPS.CSTPSCCR dependencies on BOM_RESOURCES

Line 942: SELECT /*+ ORDERED INDEX(br BOM_RESOURCES_U2)*/

938: REQUEST_ID,
939: PROGRAM_APPLICATION_ID,
940: PROGRAM_ID,
941: PROGRAM_UPDATE_DATE)
942: SELECT /*+ ORDERED INDEX(br BOM_RESOURCES_U2)*/
943: bor.ASSEMBLY_ITEM_ID,
944: l_dest_cost_type_id,
945: l_rollup_date,
946: l_last_updated_by,

Line 993: BOM_RESOURCES br,

989: CST_ITEM_COSTS cia,
990: BOM_OPERATIONAL_ROUTINGS bor,
991: BOM_OPERATION_SEQUENCES bos,
992: BOM_OPERATION_RESOURCES bomres,
993: BOM_RESOURCES br,
994: CST_RESOURCE_COSTS crc
995: WHERE csllc.ROLLUP_ID = l_rollup_id
996: AND cia.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
997: AND cia.ORGANIZATION_ID = csllc.organization_id

Line 1135: SELECT /*+ ORDERED INDEX(br BOM_RESOURCES_U2)*/

1131: request_id,
1132: program_application_id,
1133: program_id,
1134: program_update_date)
1135: SELECT /*+ ORDERED INDEX(br BOM_RESOURCES_U2)*/
1136: bor.assembly_item_id,
1137: l_dest_cost_type_id,
1138: l_rollup_date,
1139: l_last_updated_by,

Line 1173: BOM_RESOURCES br

1169: CST_ITEM_COSTS cia,
1170: BOM_OPERATIONAL_ROUTINGS bor,
1171: BOM_OPERATION_SEQUENCES bos,
1172: BOM_OPERATION_RESOURCES bomres,
1173: BOM_RESOURCES br
1174: WHERE csllc.rollup_id = l_rollup_id
1175: AND cia.inventory_item_id = csllc.inventory_item_id
1176: AND cia.organization_id = csllc.organization_id
1177: AND cia.cost_type_id = l_dest_cost_type_id