APPS.WIP_OSP dependencies on BOM_RESOURCES

Line 127: bom_resources br

123: SELECT br.PURCHASE_ITEM_ID
124: into l_osp_item_id
125: from wip_entities we,
126: wip_operation_resources wor,
127: bom_resources br
128: where we.wip_entity_id = p_wip_entity_id
129: and we.organization_id = p_organization_id
130: and wor.wip_entity_id = we.wip_entity_id
131: and wor.organization_id = we.organization_id

Line 247: bom_resources br

243: SELECT br.PURCHASE_ITEM_ID
244: into l_osp_item_id
245: from wip_entities we,
246: wip_operation_resources wor,
247: bom_resources br
248: where we.wip_entity_id = p_wip_entity_id
249: and we.organization_id = p_organization_id
250: and wor.wip_entity_id = we.wip_entity_id
251: and wor.organization_id = we.organization_id

Line 567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

563: HR_ORGANIZATION_INFORMATION hoi,
564: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
565: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
566: FND_USER fu, BOM_DEPARTMENTS bd,
567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
569: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
570: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
571: WHERE op1.organization_id = wor.organization_id

Line 751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

747: HR_ORGANIZATION_INFORMATION hoi,
748: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
749: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
750: FND_USER fu, BOM_DEPARTMENTS bd,
751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
753: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
754: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
755: WHERE op1.organization_id = wor.organization_id