DBA Data[Home] [Help]

APPS.WSMPVCPD dependencies on BOM_INVENTORY_COMPONENTS

Line 514: FROM bom_inventory_components bic

510: CURSOR C (x_bill_seq_id NUMBER) IS
511: SELECT 1
512: FROM sys.dual
513: WHERE EXISTS (SELECT 1
514: FROM bom_inventory_components bic
515: WHERE bic.bill_sequence_id = x_bill_seq_id
516: AND ((x_disable_date is NULL)
517: OR (x_disable_date > bic.effectivity_date))
518: AND ((x_effectivity_date < bic.disable_date)