DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_INVENTORY_COMPONENTS

Line 1048: FROM bom_inventory_components bic

1044: WHERE bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id;
1045:
1046: SELECT count(*)
1047: INTO l_count
1048: FROM bom_inventory_components bic
1049: WHERE bic.bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id
1050: AND nvl(bic.disable_date, sysdate + 1) >= sysdate --- Bug: 3448641
1051: AND not exists
1052: (SELECT 'x'

Line 1162: FROM bom_inventory_components bic,

1158: --
1159: BEGIN
1160: SELECT count(*)
1161: INTO l_count
1162: FROM bom_inventory_components bic,
1163: bom_substitute_components bsc
1164: WHERE bic.bill_sequence_id =p_bom_head_unexp_rec.source_bill_sequence_id
1165: AND bic.component_sequence_id = bsc.component_sequence_id
1166: AND bsc.substitute_component_id not in