APPS.ASO_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 630: /* 2633507 - hyang: use mtl_system_items_b instead of vl */

626: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
627: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
628: IS
629:
630: /* 2633507 - hyang: use mtl_system_items_b instead of vl */
631:
632: CURSOR C_Inventory_Item IS
633: SELECT start_date_active, end_date_active,vendor_warranty_flag,service_item_flag FROM MTL_SYSTEM_ITEMS_B
634: WHERE inventory_item_id = p_inventory_item_id

Line 633: SELECT start_date_active, end_date_active,vendor_warranty_flag,service_item_flag FROM MTL_SYSTEM_ITEMS_B

629:
630: /* 2633507 - hyang: use mtl_system_items_b instead of vl */
631:
632: CURSOR C_Inventory_Item IS
633: SELECT start_date_active, end_date_active,vendor_warranty_flag,service_item_flag FROM MTL_SYSTEM_ITEMS_B
634: WHERE inventory_item_id = p_inventory_item_id
635: and organization_id = p_organization_id;
636:
637: l_start_date DATE;

Line 982: FROM mtl_system_items_b

978: IS
979:
980: CURSOR C_service_item IS
981: SELECT inventory_item_id, service_item_flag
982: FROM mtl_system_items_b
983: WHERE inventory_item_id = p_inventory_item_id
984: AND organization_id = p_organization_id;
985:
986: l_inventory_item_id NUMBER;

Line 3913: FROM mtl_system_items msi, hr_organization_units org

3909: -- hr_organization_units
3910:
3911: CURSOR c_org_id is
3912: SELECT org.organization_id
3913: FROM mtl_system_items msi, hr_organization_units org
3914: WHERE msi.inventory_item_id = p_qte_line_rec.inventory_item_id
3915: AND org.organization_id= msi.organization_id
3916: AND sysdate <= nvl( org.date_to, sysdate)
3917: AND org.organization_id= p_shipment_rec.ship_from_org_id