DBA Data[Home] [Help]

APPS.BOMPIINQ dependencies on STANDARD

Line 607: And msi1.bom_item_type = 4 -- Standard

603: Where msi1.inventory_item_id = P_Parent_Item
604: And msi1.organization_id = org_id
605: And msi2.inventory_item_id = P_Comp_Item
606: And msi2.organization_id = org_id
607: And msi1.bom_item_type = 4 -- Standard
608: And msi1.replenish_to_order_flag = 'Y'
609: And msi1.base_item_id is not null -- configured item
610: And msi2.bom_item_type in (1, 2); -- model or option class
611: Cursor Check_Disabled_Parent(

Line 1141: And msi1.bom_item_type = 4 -- Standard

1137: Where msi1.inventory_item_id = P_Parent_Item
1138: And msi1.organization_id = org_id
1139: And msi2.inventory_item_id = P_Comp_Item
1140: And msi2.organization_id = org_id
1141: And msi1.bom_item_type = 4 -- Standard
1142: And msi1.replenish_to_order_flag = 'Y'
1143: And msi1.base_item_id is not null -- configured item
1144: And msi2.bom_item_type in (1, 2); -- model or option class
1145: Cursor Check_Disabled_Parent(