eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_LINES2 dependencies on DUAL

Line 107: FROM DUAL

103: p_over_tolerance_err_flag_tbl(i),
104: 'OVER_TOLERANCE_ERROR_FLAG',
105: p_over_tolerance_err_flag_tbl(i),
106: PO_VAL_CONSTANTS.c_over_tolerance_error_flag
107: FROM DUAL
108: WHERE p_over_tolerance_err_flag_tbl(i) IS NOT NULL AND
109: NOT EXISTS(
110: SELECT 1
111: FROM po_lookup_codes plc

Line 263: FROM DUAL

259: c_entity_type_line,
260: p_id_tbl(i),
261: 'PO_PDOI_GA_OSP_NA',
262: PO_VAL_CONSTANTS.c_ga_flag_op
263: FROM DUAL
264: WHERE p_line_type_id_tbl(i) IS NOT NULL
265: AND EXISTS(
266: SELECT 1
267: FROM po_line_types_b plt

Line 553: FROM DUAL

549: p_job_id_tbl(i),
550: 'JOB_BG_ID',
551: p_job_business_group_id_tbl(i),
552: PO_VAL_CONSTANTS.c_job_id_valid
553: FROM DUAL
554: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
555: AND NOT EXISTS(
556: SELECT 1
557: FROM per_jobs_vl pj, financials_system_parameters fsp

Line 598: FROM DUAL

594: p_job_id_tbl(i),
595: 'JOB_BG_ID',
596: p_job_business_group_id_tbl(i),
597: PO_VAL_CONSTANTS.c_job_id_valid
598: FROM DUAL
599: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
600: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
601: AND NOT EXISTS(
602: SELECT 1

Line 639: FROM DUAL

635: 'PO_PDOI_SVC_INVALID_JOB_CAT',
636: 'JOB_ID',
637: p_job_id_tbl(i),
638: PO_VAL_CONSTANTS.c_job_id_valid_cat
639: FROM DUAL
640: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
641: AND p_category_id_tbl(i) IS NOT NULL
642: AND NOT EXISTS(
643: SELECT 1

Line 719: FROM DUAL

715: 'PO_PDOI_SVC_CANNOT_CROSS_BG',
716: 'JOB_BUSINESS_GROUP_ID',
717: p_job_business_group_id_tbl(i),
718: PO_VAL_CONSTANTS.c_job_bg_id_not_cross_bg
719: FROM DUAL
720: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
721: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
722: AND NOT EXISTS(SELECT 1
723: FROM financials_system_parameters fsp

Line 749: FROM DUAL

745: 'PO_PDOI_SVC_INVALID_BG',
746: 'JOB_BUSINESS_GROUP_ID',
747: p_job_business_group_id_tbl(i),
748: PO_VAL_CONSTANTS.c_job_business_group_id_valid
749: FROM DUAL
750: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
751: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
752: AND NOT EXISTS(
753: SELECT 1

Line 893: FROM DUAL

889: p_un_number_id_tbl(i),
890: 'VALUE',
891: p_un_number_id_tbl(i),
892: PO_VAL_CONSTANTS.c_un_number_id_valid
893: FROM DUAL
894: WHERE p_un_number_id_tbl(i) IS NOT NULL
895: AND p_purchase_basis_tbl(i) <> 'TEMP LABOR'
896: AND NOT EXISTS(SELECT 1
897: FROM po_un_numbers_val_v pun

Line 984: FROM DUAL

980: p_hazard_class_id_tbl(i),
981: 'VALUE',
982: p_hazard_class_id_tbl(i),
983: PO_VAL_CONSTANTS.c_hazard_class_id_valid
984: FROM DUAL
985: WHERE p_hazard_class_id_tbl(i) IS NOT NULL
986: AND p_purchase_basis_tbl(i) <> 'TEMP LABOR'
987: AND NOT EXISTS(SELECT 'Y'
988: FROM po_hazard_classes_val_v phc

Line 1090: FROM DUAL

1086: 'PO_PDOI_ITEM_NOT_NULL',
1087: 'ITEM_ID',
1088: p_item_id_tbl(i),
1089: PO_VAL_CONSTANTS.c_item_id_not_null
1090: FROM DUAL
1091: WHERE p_order_type_lookup_code_tbl(i) = 'QUANTITY'
1092: AND p_item_id_tbl(i) IS NULL
1093: AND EXISTS(
1094: SELECT 1

Line 1220: FROM DUAL

1216: DECODE(p_item_description_tbl(i), NULL, 'COLUMN_NAME', NULL),
1217: DECODE(p_item_description_tbl(i), NULL, 'ITEM_DESCRIPTION', NULL),
1218: DECODE(p_item_description_tbl(i), NULL, PO_VAL_CONSTANTS.c_item_desc_not_null,
1219: PO_VAL_CONSTANTS.c_item_desc_not_updatable)
1220: FROM DUAL
1221: WHERE p_item_description_tbl(i) IS NULL
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(

Line 1350: FROM DUAL

1346: 'UNIT_MEAS_LOOKUP_CODE',
1347: p_unit_meas_lookup_code_tbl(i),
1348: p_item_id_tbl(i),
1349: PO_VAL_CONSTANTS.c_unit_meas_lookup_item
1350: FROM DUAL
1351: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1352: AND p_item_id_tbl(i) IS NOT NULL
1353: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL
1354: AND NOT EXISTS(

Line 1388: FROM DUAL

1384: p_unit_meas_lookup_code_tbl(i),
1385: 'VALUE',
1386: p_unit_meas_lookup_code_tbl(i),
1387: PO_VAL_CONSTANTS.c_unit_meas_lookup_valid
1388: FROM DUAL
1389: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1390: AND p_item_id_tbl(i) IS NULL
1391: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL
1392: AND NOT EXISTS(SELECT 1

Line 1468: FROM DUAL

1464: 'VALUE',
1465: 'UNIT_MEAS_LOOKUP_CODE',
1466: p_unit_meas_lookup_code_tbl(i),
1467: PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid
1468: FROM DUAL
1469: WHERE p_order_type_lookup_code_tbl(i) = 'RATE'
1470: AND NOT EXISTS(SELECT 1
1471: FROM mtl_units_of_measure_vl muomv
1472: WHERE muomv.uom_class = l_service_uom_class

Line 1573: FROM DUAL

1569: 'item_revision',
1570: p_item_revision_tbl(i),
1571: p_item_id_tbl(i),
1572: PO_VAL_CONSTANTS.c_item_revision_item
1573: FROM DUAL
1574: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1575: AND p_item_revision_tbl(i) IS NOT NULL
1576: AND p_item_id_tbl(i) IS NOT NULL
1577: AND NOT EXISTS(SELECT 1

Line 1685: FROM DUAL

1681: p_category_id_tbl(i),
1682: 'ITEM',
1683: p_item_id_tbl(i),
1684: PO_VAL_CONSTANTS.c_category_id_item
1685: FROM DUAL
1686: WHERE p_order_type_lookup_code_tbl(i) NOT IN('FIXED PRICE', 'RATE')
1687: AND p_item_id_tbl(i) IS NOT NULL
1688: AND p_category_id_tbl(i) IS NOT NULL
1689: AND NOT EXISTS(

Line 1727: FROM DUAL

1723: p_category_id_tbl(i),
1724: 'VALUE',
1725: p_category_id_tbl(i),
1726: PO_VAL_CONSTANTS.c_category_id_valid
1727: FROM DUAL
1728: WHERE p_order_type_lookup_code_tbl(i) NOT IN('FIXED PRICE', 'RATE')
1729: AND p_item_id_tbl(i) IS NULL
1730: AND p_category_id_tbl(i) IS NOT NULL
1731: AND NOT EXISTS(

Line 1768: FROM DUAL

1764: p_category_id_tbl(i),
1765: 'VALUE',
1766: p_category_id_tbl(i),
1767: PO_VAL_CONSTANTS.c_category_id_valid
1768: FROM DUAL
1769: WHERE p_order_type_lookup_code_tbl(i) NOT IN('FIXED PRICE', 'RATE')
1770: AND p_item_id_tbl(i) IS NULL
1771: AND p_category_id_tbl(i) IS NOT NULL
1772: AND NOT EXISTS(

Line 1866: FROM DUAL

1862: p_ip_category_id_tbl(i),
1863: 'VALUE',
1864: p_ip_category_id_tbl(i),
1865: PO_VAL_CONSTANTS.c_ip_category_id_valid
1866: FROM DUAL
1867: WHERE p_ip_category_id_tbl(i) IS NOT NULL
1868: AND p_ip_category_id_tbl(i) <> -2
1869: AND NOT EXISTS(
1870: SELECT 'Y'

Line 1989: FROM DUAL

1985: 'VALUE',
1986: 'UNIT_PRICE',
1987: p_unit_price_tbl(i),
1988: PO_VAL_CONSTANTS.c_unit_price_line_type
1989: FROM DUAL
1990: WHERE p_line_type_id_tbl(i) IS NOT NULL
1991: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
1992: AND NOT EXISTS(SELECT 1
1993: FROM po_line_types_b plt

Line 2292: FROM DUAL

2288: p_line_num_tbl(i),
2289: 'VALUE',
2290: p_line_num_tbl(i),
2291: PO_VAL_CONSTANTS.c_line_num_unique
2292: FROM DUAL
2293: WHERE p_po_header_id_tbl(i) IS NOT NULL
2294: AND p_line_num_tbl(i) IS NOT NULL
2295: AND (EXISTS(SELECT 'Y'
2296: FROM po_lines_all pln

Line 2380: FROM DUAL

2376: 'VALUE',
2377: p_po_line_id_tbl(i),
2378: DECODE(p_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_line_id_not_null,
2379: PO_VAL_CONSTANTS.c_po_line_id_unique)
2380: FROM DUAL
2381: WHERE p_po_line_id_tbl(i) IS NULL
2382: OR ( p_po_header_id_tbl(i) IS NOT NULL
2383: AND EXISTS(SELECT 1
2384: FROM po_lines pln

Line 2455: FROM DUAL

2451: 'VALUE',
2452: p_line_type_id_tbl(i),
2453: DECODE(p_line_type_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_line_type_id_not_null,
2454: PO_VAL_CONSTANTS.c_line_type_id_valid)
2455: FROM DUAL
2456: WHERE p_line_type_id_tbl(i) IS NULL OR
2457: NOT EXISTS(SELECT 1
2458: FROM po_line_types_val_v pltv
2459: WHERE pltv.line_type_id = p_line_type_id_tbl(i));

Line 2574: FROM DUAL

2570: p_style_id_tbl(i),
2571: 'PURCHASE_BASIS',
2572: p_purchase_basis_tbl(i),
2573: PO_VAL_CONSTANTS.c_line_style_on_purchase_basis
2574: FROM DUAL
2575: WHERE NOT EXISTS(SELECT 1
2576: FROM po_doc_style_values pdsv
2577: WHERE pdsv.style_id = p_style_id_tbl(i)
2578: AND pdsv.style_attribute_name = 'PURCHASE_BASES'

Line 2645: FROM DUAL

2641: p_price_type_lookup_code_tbl(i),
2642: 'VALUE',
2643: p_price_type_lookup_code_tbl(i),
2644: PO_VAL_CONSTANTS.c_price_type_lookup_code
2645: FROM DUAL
2646: WHERE p_price_type_lookup_code_tbl(i) IS NOT NULL
2647: AND NOT EXISTS(
2648: SELECT 'Y'
2649: FROM po_lookup_codes plc

Line 2804: FROM DUAL

2800: 'ITEM_ID',
2801: p_item_id_tbl(i),
2802: 'ITEM_ID',
2803: p_item_id_tbl(i)
2804: FROM DUAL
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

Line 3008: FROM DUAL

3004: 'PRICE_BREAK_LOOKUP_CODE',
3005: p_price_break_lookup_code_tbl(i),
3006: 'VALUE',
3007: p_price_break_lookup_code_tbl(i)
3008: FROM DUAL
3009: WHERE p_price_break_lookup_code_tbl(i) IS NOT NULL
3010: AND p_price_break_lookup_code_tbl(i) NOT IN
3011: ( SELECT lookup_code
3012: FROM po_lookup_codes PLC

Line 3197: FROM DUAL

3193: p_ip_category_id_tbl(i),
3194: 'VALUE',
3195: p_ip_category_id_tbl(i),
3196: PO_VAL_CONSTANTS.c_ip_cat_id_update_valid
3197: FROM DUAL
3198: WHERE p_ip_category_id_tbl(i) IS NOT NULL
3199: AND p_ip_category_id_tbl(i) <> -2
3200: AND NOT EXISTS(
3201: SELECT 'Y'

Line 3288: FROM DUAL

3284: p_unit_meas_lookup_code_tbl(i),
3285: 'UNIT_MEAS_LOOKUP_CODE',
3286: p_unit_meas_lookup_code_tbl(i),
3287: PO_VAL_CONSTANTS.c_uom_update_valid
3288: FROM DUAL
3289: WHERE EXISTS(
3290: SELECT 1
3291: FROM po_lines_all pol,
3292: po_units_of_measure_val_v pumv

Line 3398: FROM DUAL

3394: p_item_description_tbl(i),
3395: 'ITEM_DESCRIPTION',
3396: p_item_description_tbl(i),
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,

Line 3623: FROM DUAL

3619: 'PO_PDOI_NO_PO_CAT_UPDATE',
3620: 'CATEGORY_ID',
3621: p_category_id_tbl(i),
3622: PO_VAL_CONSTANTS.c_cat_id_update_not_updatable
3623: FROM DUAL
3624: WHERE p_category_id_tbl(i) IS NOT NULL
3625: AND (p_item_id_tbl(i) IS NOT NULL OR p_job_id_tbl(i) IS NOT NULL)
3626: AND (EXISTS(SELECT 1
3627: FROM po_lines_all pol