[Home] [Help]
1100: IF (SQL%ROWCOUNT > 0) THEN
1101: x_result_type := po_validations.c_result_type_failure;
1102: END IF;
1103:
1104: -- if item id is not null, it has to exist in mtl_system_items table
1105: FORALL i IN 1 .. p_id_tbl.COUNT
1106: INSERT INTO po_validation_results_gt
1107: (result_set_id,
1108: result_type,
1131: AND p_line_type_id_tbl(i) = plt.line_type_id
1132: AND plt.outside_operation_flag IS NOT NULL
1133: AND NOT EXISTS(
1134: SELECT 1
1135: FROM mtl_system_items msi
1136: WHERE msi.inventory_item_id = p_item_id_tbl(i)
1137: AND msi.organization_id = p_inventory_org_id
1138: AND msi.enabled_flag = 'Y'
1139: AND msi.purchasing_item_flag = 'Y'
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
2805: WHERE p_item_id_tbl(i) IS NOT NULL
2806: AND p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
2807: AND EXISTS(
2808: SELECT 1
2809: FROM mtl_system_items msi
2810: WHERE msi.inventory_item_id = p_item_id_tbl(i)
2811: AND msi.organization_id = p_inventory_org_id
2812: AND msi.bom_item_type IN(1, 2));
2813:
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
3397: PO_VAL_CONSTANTS.c_item_desc_update_unupdatable
3398: FROM DUAL
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
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
3414: (p_item_description_tbl(i) <> mtl.description OR
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
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