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 992: BOM_RESOURCES br,

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

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

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

Line 1172: BOM_RESOURCES br

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