DBA Data[Home] [Help]

APPS.MRP_VALIDATE_FLOW_SCHEDULE dependencies on BOM_BILL_NO_HOLD_REVISIONS_V

Line 321: FROM bom_bill_no_hold_revisions_v

317: BEGIN
318:
319: SELECT 'VALID'
320: INTO l_dummy
321: FROM bom_bill_no_hold_revisions_v
322: WHERE inventory_item_id = l_flow_schedule_rec.primary_item_id
323: AND organization_id = l_flow_schedule_rec.organization_id
324: AND revision = l_flow_schedule_rec.bom_revision
325: AND l_flow_schedule_rec.bom_revision_date >= --fix bug#3170105