DBA Data[Home] [Help]

APPS.BOMPIINQ dependencies on STANDARD

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

618: Where msi1.inventory_item_id = P_Parent_Item
619: And msi1.organization_id = org_id
620: And msi2.inventory_item_id = P_Comp_Item
621: And msi2.organization_id = org_id
622: And msi1.bom_item_type = 4 -- Standard
623: And msi1.replenish_to_order_flag = 'Y'
624: And msi1.base_item_id is not null -- configured item
625: And msi2.bom_item_type in (1, 2); -- model or option class
626: Cursor Check_Disabled_Parent(

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

1166: Where msi1.inventory_item_id = P_Parent_Item
1167: And msi1.organization_id = org_id
1168: And msi2.inventory_item_id = P_Comp_Item
1169: And msi2.organization_id = org_id
1170: And msi1.bom_item_type = 4 -- Standard
1171: And msi1.replenish_to_order_flag = 'Y'
1172: And msi1.base_item_id is not null -- configured item
1173: And msi2.bom_item_type in (1, 2); -- model or option class
1174: Cursor Check_Disabled_Parent(