[Home] [Help]
1200: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1201: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1202: END IF;
1203:
1204: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
1205: x_result_type := po_validations.c_result_type_success;
1206: FORALL i IN 1 .. p_id_tbl.COUNT
1207: INSERT INTO po_validation_results_gt
1208: (result_set_id,
1231: OR ( p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1232: AND p_item_id_tbl(i) IS NOT NULL
1233: AND EXISTS(
1234: SELECT 1 FROM
1235: mtl_system_items msi,mtl_system_items_tl mtl
1236: where msi.inventory_item_id = p_item_id_tbl(i) AND
1237: mtl.inventory_item_id = msi.inventory_item_id
1238: AND msi.organization_id = p_inventory_org_id
1239: AND mtl.organization_id = msi.organization_id
3433: x_result_type := po_validations.c_result_type_failure;
3434: END IF;
3435: END LOOP;
3436:
3437: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
3438:
3439:
3440: FORALL i IN 1 .. p_id_tbl.COUNT
3441: INSERT INTO po_validation_results_gt
3463: WHERE EXISTS(
3464: SELECT 1
3465: FROM mtl_system_items msi,
3466: po_lines_all pol,
3467: mtl_system_items_tl mtl
3468: WHERE p_po_line_id_tbl(i) IS NOT NULL AND
3469: p_item_id_tbl(i) IS NOT NULL AND
3470: pol.po_header_id = nvl(p_po_header_id_tbl(i),pol.po_header_id) AND
3471: pol.po_line_id = p_po_line_id_tbl(i) AND
3479: p_item_description_tbl(i) <> pol.item_description))
3480: OR EXISTS(
3481: SELECT 1
3482: FROM mtl_system_items msi,
3483: mtl_system_items_tl mtl
3484: WHERE p_po_line_id_tbl(i) IS NULL AND
3485: p_item_id_tbl(i) IS NOT NULL AND
3486: msi.inventory_item_id = p_item_id_tbl(i) AND
3487: mtl.inventory_item_id = msi.inventory_item_id AND