DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_COMPONENTS_B

Line 5926: FROM BOM_COMPONENTS_B bic

5922: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
5923: AND bsb.assembly_item_id = sitm.revised_item_id
5924: AND bsb.organization_id = sitm.organization_id
5925: AND EXISTS ( SELECT 1
5926: FROM BOM_COMPONENTS_B bic
5927: WHERE bic.bill_sequence_id = bsb.bill_sequence_id and
5928: (bic.FROM_END_ITEM_REV_ID = sitm.new_item_revision_id
5929: OR bic.TO_END_ITEM_REV_ID = sitm.new_item_revision_id
5930: ))

Line 5936: FROM BOM_COMPONENTS_B bic

5932: SELECT 1
5933: FROM eng_revised_items sitm
5934: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
5935: AND EXISTS ( SELECT 1
5936: FROM BOM_COMPONENTS_B bic
5937: WHERE bic.component_item_id = sitm.revised_item_id and
5938: bic.COMPONENT_ITEM_REVISION_ID = sitm.new_item_revision_id);
5939:
5940: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;