APPS.OE_BULK_PROCESS_LINE dependencies on MTL_SYSTEM_ITEMS

Line 580: FROM mtl_system_items_vl

576:
577: BEGIN
578: SELECT inventory_item_id
579: INTO l_inventory_item_id_int
580: FROM mtl_system_items_vl
581: WHERE concatenated_segments = l_inventory_item
582: AND customer_order_enabled_flag = 'Y'
583: AND bom_item_type in (1,2,4)
584: AND organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG;

Line 827: from mtl_system_items

823: OR
824: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
825: and nvl(p_order_source_id, -1) = 10
826: and 'N' = (select inventory_asset_flag
827: from mtl_system_items
828: where inventory_item_id = p_inventory_item_id
829: and organization_id = p_ship_from_org_id
830: )
831: )

Line 836: from mtl_system_items

832: OR
833: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
834: and nvl(p_order_source_id, -1) = 10
835: and 'Y' = (select inventory_asset_flag
836: from mtl_system_items
837: where inventory_item_id = p_inventory_item_id
838: and organization_id = p_ship_from_org_id
839: )
840: and sub.asset_inventory = 1

Line 886: FROM mtl_system_items msi,

882: --hr_all_organization_units
883:
884: /* SELECT null
885: INTO l_dummy
886: FROM mtl_system_items msi,
887: org_organization_definitions org
888: WHERE msi.inventory_item_id = p_inventory_item_id
889: AND org.organization_id= msi.organization_id
890: AND msi.internal_order_enabled_flag = 'Y'

Line 898: FROM mtl_system_items msi,

894: */
895:
896: SELECT null
897: INTO l_dummy
898: FROM mtl_system_items msi,
899: hr_all_organization_units org
900: WHERE msi.inventory_item_id = p_inventory_item_id
901: AND org.organization_id= msi.organization_id
902: AND msi.internal_order_enabled_flag = 'Y'

Line 920: FROM mtl_system_items msi,

916: --hr_all_organization_units
917:
918: /* SELECT null
919: INTO l_dummy
920: FROM mtl_system_items msi,
921: org_organization_definitions org
922: WHERE msi.inventory_item_id = p_inventory_item_id
923: AND org.organization_id= msi.organization_id
924: AND sysdate <= nvl( org.disable_date, sysdate)

Line 931: FROM mtl_system_items msi,

927: */
928:
929: SELECT null
930: INTO l_dummy
931: FROM mtl_system_items msi,
932: hr_all_organization_units org
933: WHERE msi.inventory_item_id = p_inventory_item_id
934: AND org.organization_id= msi.organization_id
935: AND sysdate <= nvl( org.date_to, sysdate)

Line 945: FROM mtl_system_items msi,

941: --hr_all_organization_units
942:
943: /* SELECT null
944: INTO l_dummy
945: FROM mtl_system_items msi,
946: org_organization_definitions org
947: WHERE msi.inventory_item_id = p_inventory_item_id
948: AND org.organization_id= msi.organization_id
949: AND msi.customer_order_enabled_flag = 'Y'

Line 957: FROM mtl_system_items msi,

953: */
954:
955: SELECT null
956: INTO l_dummy
957: FROM mtl_system_items msi,
958: hr_all_organization_units org
959: WHERE msi.inventory_item_id = p_inventory_item_id
960: AND org.organization_id= msi.organization_id
961: AND msi.customer_order_enabled_flag = 'Y'

Line 1138: ,mtl_system_items_vl sitems

1134: SELECT 'valid'
1135: INTO l_dummy
1136: FROM mtl_customer_items citems
1137: ,mtl_customer_item_xrefs cxref
1138: ,mtl_system_items_vl sitems
1139: WHERE citems.customer_item_id = cxref.customer_item_id
1140: AND cxref.inventory_item_id = sitems.inventory_item_id
1141: AND sitems.inventory_item_id = p_inventory_item_id
1142: AND sitems.organization_id =

Line 1153: ,mtl_system_items_vl sitems

1149: SELECT 'valid'
1150: INTO l_dummy
1151: FROM mtl_customer_items citems
1152: ,mtl_customer_item_xrefs cxref
1153: ,mtl_system_items_vl sitems
1154: WHERE citems.customer_item_id = cxref.customer_item_id
1155: AND cxref.inventory_item_id = sitems.inventory_item_id
1156: AND sitems.inventory_item_id = p_inventory_item_id
1157: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG

Line 1171: , mtl_system_items_vl sitems

1167: SELECT 'valid'
1168: INTO l_dummy
1169: FROM mtl_cross_reference_types types
1170: , mtl_cross_references items
1171: , mtl_system_items_vl sitems
1172: WHERE types.cross_reference_type = items.cross_reference_type
1173: AND items.inventory_item_id = sitems.inventory_item_id
1174: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG
1175: AND sitems.inventory_item_id = p_inventory_item_id

Line 2793: FROM mtl_system_items

2789:
2790: BEGIN
2791: SELECT primary_uom_code
2792: INTO l_uom
2793: FROM mtl_system_items
2794: WHERE inventory_item_id=p_line_rec.inventory_item_id(l_index)
2795: AND organization_id=nvl(p_line_rec.ship_from_org_id(l_index),
2796: OE_Bulk_Order_PVT.G_ITEM_ORG);
2797: