[Home] [Help]
602:
603: BEGIN
604: SELECT inventory_item_id
605: INTO l_inventory_item_id_int
606: FROM mtl_system_items_vl
607: WHERE concatenated_segments = l_inventory_item
608: AND customer_order_enabled_flag = 'Y'
609: AND bom_item_type in (1,2,4)
610: AND organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG;
849: OR
850: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
851: and nvl(p_order_source_id, -1) = 10
852: and 'N' = (select inventory_asset_flag
853: from mtl_system_items
854: where inventory_item_id = p_inventory_item_id
855: and organization_id = p_ship_from_org_id
856: )
857: )
858: OR
859: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
860: and nvl(p_order_source_id, -1) = 10
861: and 'Y' = (select inventory_asset_flag
862: from mtl_system_items
863: where inventory_item_id = p_inventory_item_id
864: and organization_id = p_ship_from_org_id
865: )
866: and sub.asset_inventory = 1
908: --hr_all_organization_units
909:
910: /* SELECT null
911: INTO l_dummy
912: FROM mtl_system_items msi,
913: org_organization_definitions org
914: WHERE msi.inventory_item_id = p_inventory_item_id
915: AND org.organization_id= msi.organization_id
916: AND msi.internal_order_enabled_flag = 'Y'
920: */
921:
922: SELECT null
923: INTO l_dummy
924: FROM mtl_system_items msi,
925: hr_all_organization_units org
926: WHERE msi.inventory_item_id = p_inventory_item_id
927: AND org.organization_id= msi.organization_id
928: AND msi.internal_order_enabled_flag = 'Y'
942: --hr_all_organization_units
943:
944: /* SELECT null
945: INTO l_dummy
946: FROM mtl_system_items msi,
947: org_organization_definitions org
948: WHERE msi.inventory_item_id = p_inventory_item_id
949: AND org.organization_id= msi.organization_id
950: AND sysdate <= nvl( org.disable_date, sysdate)
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 sysdate <= nvl( org.date_to, sysdate)
967: --hr_all_organization_units
968:
969: /* SELECT null
970: INTO l_dummy
971: FROM mtl_system_items msi,
972: org_organization_definitions org
973: WHERE msi.inventory_item_id = p_inventory_item_id
974: AND org.organization_id= msi.organization_id
975: AND msi.customer_order_enabled_flag = 'Y'
979: */
980:
981: SELECT null
982: INTO l_dummy
983: FROM mtl_system_items msi,
984: hr_all_organization_units org
985: WHERE msi.inventory_item_id = p_inventory_item_id
986: AND org.organization_id= msi.organization_id
987: AND msi.customer_order_enabled_flag = 'Y'
1160: SELECT 'valid'
1161: INTO l_dummy
1162: FROM mtl_customer_items citems
1163: ,mtl_customer_item_xrefs cxref
1164: ,mtl_system_items_vl sitems
1165: WHERE citems.customer_item_id = cxref.customer_item_id
1166: AND cxref.inventory_item_id = sitems.inventory_item_id
1167: AND sitems.inventory_item_id = p_inventory_item_id
1168: AND sitems.organization_id =
1175: SELECT 'valid'
1176: INTO l_dummy
1177: FROM mtl_customer_items citems
1178: ,mtl_customer_item_xrefs cxref
1179: ,mtl_system_items_vl sitems
1180: WHERE citems.customer_item_id = cxref.customer_item_id
1181: AND cxref.inventory_item_id = sitems.inventory_item_id
1182: AND sitems.inventory_item_id = p_inventory_item_id
1183: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG
1193: SELECT 'valid'
1194: INTO l_dummy
1195: FROM mtl_cross_reference_types types
1196: , mtl_cross_references items
1197: , mtl_system_items_vl sitems
1198: WHERE types.cross_reference_type = items.cross_reference_type
1199: AND items.inventory_item_id = sitems.inventory_item_id
1200: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG
1201: AND sitems.inventory_item_id = p_inventory_item_id
2844:
2845: BEGIN
2846: SELECT primary_uom_code
2847: INTO l_uom
2848: FROM mtl_system_items
2849: WHERE inventory_item_id=p_line_rec.inventory_item_id(l_index)
2850: AND organization_id=nvl(p_line_rec.ship_from_org_id(l_index),
2851: OE_Bulk_Order_PVT.G_ITEM_ORG);
2852: