APPS.WIP_OSP dependencies on BOM_RESOURCES

Line 139: bom_resources br

135: SELECT br.PURCHASE_ITEM_ID
136: into l_osp_item_id
137: from wip_entities we,
138: wip_operation_resources wor,
139: bom_resources br
140: where we.wip_entity_id = p_wip_entity_id
141: and we.organization_id = p_organization_id
142: and wor.wip_entity_id = we.wip_entity_id
143: and wor.organization_id = we.organization_id

Line 260: bom_resources br

256: SELECT br.PURCHASE_ITEM_ID
257: into l_osp_item_id
258: from wip_entities we,
259: wip_operation_resources wor,
260: bom_resources br
261: where we.wip_entity_id = p_wip_entity_id
262: and we.organization_id = p_organization_id
263: and wor.wip_entity_id = we.wip_entity_id
264: and wor.organization_id = we.organization_id

Line 615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

611: HR_ORGANIZATION_INFORMATION hoi,
612: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
614: FND_USER fu, BOM_DEPARTMENTS bd,
615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
616: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
617: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
618: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
619: WHERE op1.organization_id = wor.organization_id

Line 808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

804: HR_ORGANIZATION_INFORMATION hoi,
805: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
807: FND_USER fu, BOM_DEPARTMENTS bd,
808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
809: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
810: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
811: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
812: WHERE op1.organization_id = wor.organization_id