APPS.ASO_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS_B

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;