DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_COMPONENTS_B

Line 6012: FROM BOM_COMPONENTS_B bic

6008: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
6009: AND bsb.assembly_item_id = sitm.revised_item_id
6010: AND bsb.organization_id = sitm.organization_id
6011: AND EXISTS ( SELECT 1
6012: FROM BOM_COMPONENTS_B bic
6013: WHERE bic.bill_sequence_id = bsb.bill_sequence_id and
6014: (bic.FROM_END_ITEM_REV_ID = sitm.new_item_revision_id
6015: OR bic.TO_END_ITEM_REV_ID = sitm.new_item_revision_id
6016: ))

Line 6022: FROM BOM_COMPONENTS_B bic

6018: SELECT 1
6019: FROM eng_revised_items sitm
6020: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
6021: AND EXISTS ( SELECT 1
6022: FROM BOM_COMPONENTS_B bic
6023: WHERE bic.component_item_id = sitm.revised_item_id and
6024: bic.COMPONENT_ITEM_REVISION_ID = sitm.new_item_revision_id);
6025:
6026: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;