[Home] [Help]
1191: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1192: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1193: END IF;
1194:
1195: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
1196: x_result_type := po_validations.c_result_type_success;
1197: FORALL i IN 1 .. p_id_tbl.COUNT
1198: INSERT INTO po_validation_results_gt
1199: (result_set_id,
1222: OR ( p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1223: AND p_item_id_tbl(i) IS NOT NULL
1224: AND EXISTS(
1225: SELECT 1 FROM
1226: mtl_system_items msi,mtl_system_items_tl mtl
1227: where msi.inventory_item_id = p_item_id_tbl(i) AND
1228: mtl.inventory_item_id = msi.inventory_item_id
1229: AND msi.organization_id = p_inventory_org_id
1230: AND mtl.organization_id = msi.organization_id
3369: x_result_type := po_validations.c_result_type_failure;
3370: END IF;
3371: END LOOP;
3372:
3373: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
3374:
3375:
3376: FORALL i IN 1 .. p_id_tbl.COUNT
3377: INSERT INTO po_validation_results_gt
3399: WHERE EXISTS(
3400: SELECT 1
3401: FROM mtl_system_items msi,
3402: po_lines_all pol,
3403: mtl_system_items_tl mtl
3404: WHERE p_po_line_id_tbl(i) IS NOT NULL AND
3405: p_item_id_tbl(i) IS NOT NULL AND
3406: pol.po_header_id = nvl(p_po_header_id_tbl(i),pol.po_header_id) AND
3407: pol.po_line_id = p_po_line_id_tbl(i) AND
3415: p_item_description_tbl(i) <> pol.item_description))
3416: OR EXISTS(
3417: SELECT 1
3418: FROM mtl_system_items msi,
3419: mtl_system_items_tl mtl
3420: WHERE p_po_line_id_tbl(i) IS NULL AND
3421: p_item_id_tbl(i) IS NOT NULL AND
3422: msi.inventory_item_id = p_item_id_tbl(i) AND
3423: mtl.inventory_item_id = msi.inventory_item_id AND