APPS.WIP_WOL_PROCESSOR dependencies on BOM_BILL_RELEASED_REVISIONS_V

Line 49: FROM bom_bill_released_revisions_v bbrrv

45: AND msi.inventory_item_id = wlc.inventory_item_id
46: AND msi.revision_qty_control_code = 2)
47: AND NOT EXISTS (
48: SELECT 'revision is effective and not an open/hold eco'
49: FROM bom_bill_released_revisions_v bbrrv
50: WHERE bbrrv.inventory_item_id = wlc.inventory_item_id
51: AND bbrrv.organization_id = wlc.organization_id
52: AND bbrrv.revision = wlc.bom_revision
53: AND bbrrv.effectivity_date <= SYSDATE))

Line 71: FROM bom_bill_released_revisions_v bbrrv

67: AND msi.inventory_item_id = wlc.inventory_item_id
68: AND msi.revision_qty_control_code = 2)
69: AND NOT EXISTS (
70: SELECT 'any effective revision'
71: FROM bom_bill_released_revisions_v bbrrv
72: WHERE bbrrv.inventory_item_id = wlc.inventory_item_id
73: AND bbrrv.organization_id = wlc.organization_id
74: AND bbrrv.effectivity_date <= SYSDATE))));
75: return SQL%ROWCOUNT;