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 112: FROM DUAL

108: p_over_tolerance_err_flag_tbl(i),
109: 'OVER_TOLERANCE_ERROR_FLAG',
110: p_over_tolerance_err_flag_tbl(i),
111: PO_VAL_CONSTANTS.c_over_tolerance_error_flag
112: FROM DUAL
113: WHERE p_over_tolerance_err_flag_tbl(i) IS NOT NULL AND
114: NOT EXISTS(
115: SELECT 1
116: FROM po_lookup_codes plc

Line 271: FROM DUAL

267: c_entity_type_line,
268: p_id_tbl(i),
269: 'PO_PDOI_GA_OSP_NA',
270: PO_VAL_CONSTANTS.c_ga_flag_op
271: FROM DUAL
272: WHERE p_line_type_id_tbl(i) IS NOT NULL
273: AND EXISTS(
274: SELECT 1
275: FROM po_line_types_b plt

Line 562: FROM DUAL

558: p_job_id_tbl(i),
559: 'JOB_BG_ID',
560: p_job_business_group_id_tbl(i),
561: PO_VAL_CONSTANTS.c_job_id_valid
562: FROM DUAL
563: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
564: AND NOT EXISTS(
565: SELECT 1
566: FROM per_jobs_vl pj, financials_system_parameters fsp

Line 607: FROM DUAL

603: p_job_id_tbl(i),
604: 'JOB_BG_ID',
605: p_job_business_group_id_tbl(i),
606: PO_VAL_CONSTANTS.c_job_id_valid
607: FROM DUAL
608: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
609: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
610: AND NOT EXISTS(
611: SELECT 1

Line 648: FROM DUAL

644: 'PO_PDOI_SVC_INVALID_JOB_CAT',
645: 'JOB_ID',
646: p_job_id_tbl(i),
647: PO_VAL_CONSTANTS.c_job_id_valid_cat
648: FROM DUAL
649: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
650: AND p_category_id_tbl(i) IS NOT NULL
651: AND NOT EXISTS(
652: SELECT 1

Line 728: FROM DUAL

724: 'PO_PDOI_SVC_CANNOT_CROSS_BG',
725: 'JOB_BUSINESS_GROUP_ID',
726: p_job_business_group_id_tbl(i),
727: PO_VAL_CONSTANTS.c_job_bg_id_not_cross_bg
728: FROM DUAL
729: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
730: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
731: AND NOT EXISTS(SELECT 1
732: FROM financials_system_parameters fsp

Line 758: FROM DUAL

754: 'PO_PDOI_SVC_INVALID_BG',
755: 'JOB_BUSINESS_GROUP_ID',
756: p_job_business_group_id_tbl(i),
757: PO_VAL_CONSTANTS.c_job_business_group_id_valid
758: FROM DUAL
759: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
760: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
761: AND NOT EXISTS(
762: SELECT 1

Line 902: FROM DUAL

898: p_un_number_id_tbl(i),
899: 'VALUE',
900: p_un_number_id_tbl(i),
901: PO_VAL_CONSTANTS.c_un_number_id_valid
902: FROM DUAL
903: WHERE p_un_number_id_tbl(i) IS NOT NULL
904: AND p_purchase_basis_tbl(i) <> 'TEMP LABOR'
905: AND NOT EXISTS(SELECT 1
906: FROM po_un_numbers_val_v pun

Line 993: FROM DUAL

989: p_hazard_class_id_tbl(i),
990: 'VALUE',
991: p_hazard_class_id_tbl(i),
992: PO_VAL_CONSTANTS.c_hazard_class_id_valid
993: FROM DUAL
994: WHERE p_hazard_class_id_tbl(i) IS NOT NULL
995: AND p_purchase_basis_tbl(i) <> 'TEMP LABOR'
996: AND NOT EXISTS(SELECT 'Y'
997: FROM po_hazard_classes_val_v phc

Line 1099: FROM DUAL

1095: 'PO_PDOI_ITEM_NOT_NULL',
1096: 'ITEM_ID',
1097: p_item_id_tbl(i),
1098: PO_VAL_CONSTANTS.c_item_id_not_null
1099: FROM DUAL
1100: WHERE p_order_type_lookup_code_tbl(i) = 'QUANTITY'
1101: AND p_item_id_tbl(i) IS NULL
1102: AND EXISTS(
1103: SELECT 1

Line 1229: FROM DUAL

1225: DECODE(p_item_description_tbl(i), NULL, 'COLUMN_NAME', NULL),
1226: DECODE(p_item_description_tbl(i), NULL, 'ITEM_DESCRIPTION', NULL),
1227: DECODE(p_item_description_tbl(i), NULL, PO_VAL_CONSTANTS.c_item_desc_not_null,
1228: PO_VAL_CONSTANTS.c_item_desc_not_updatable)
1229: FROM DUAL
1230: WHERE p_item_description_tbl(i) IS NULL
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(

Line 1359: FROM DUAL

1355: 'UNIT_MEAS_LOOKUP_CODE',
1356: p_unit_meas_lookup_code_tbl(i),
1357: p_item_id_tbl(i),
1358: PO_VAL_CONSTANTS.c_unit_meas_lookup_item
1359: FROM DUAL
1360: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1361: AND p_item_id_tbl(i) IS NOT NULL
1362: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL
1363: AND NOT EXISTS(

Line 1397: FROM DUAL

1393: p_unit_meas_lookup_code_tbl(i),
1394: 'VALUE',
1395: p_unit_meas_lookup_code_tbl(i),
1396: PO_VAL_CONSTANTS.c_unit_meas_lookup_valid
1397: FROM DUAL
1398: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1399: AND p_item_id_tbl(i) IS NULL
1400: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL
1401: AND NOT EXISTS(SELECT 1

Line 1477: FROM DUAL

1473: 'VALUE',
1474: 'UNIT_MEAS_LOOKUP_CODE',
1475: p_unit_meas_lookup_code_tbl(i),
1476: PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid
1477: FROM DUAL
1478: WHERE p_order_type_lookup_code_tbl(i) = 'RATE'
1479: AND NOT EXISTS(SELECT 1
1480: FROM mtl_units_of_measure_vl muomv
1481: WHERE muomv.uom_class = l_service_uom_class

Line 1582: FROM DUAL

1578: 'item_revision',
1579: p_item_revision_tbl(i),
1580: p_item_id_tbl(i),
1581: PO_VAL_CONSTANTS.c_item_revision_item
1582: FROM DUAL
1583: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1584: AND p_item_revision_tbl(i) IS NOT NULL
1585: AND p_item_id_tbl(i) IS NOT NULL
1586: AND NOT EXISTS(SELECT 1

Line 1694: FROM DUAL

1690: p_category_id_tbl(i),
1691: 'ITEM',
1692: p_item_id_tbl(i),
1693: PO_VAL_CONSTANTS.c_category_id_item
1694: FROM DUAL
1695: WHERE p_order_type_lookup_code_tbl(i) NOT IN('FIXED PRICE', 'RATE')
1696: AND p_item_id_tbl(i) IS NOT NULL
1697: AND p_category_id_tbl(i) IS NOT NULL
1698: AND NOT EXISTS(

Line 1736: FROM DUAL

1732: p_category_id_tbl(i),
1733: 'VALUE',
1734: p_category_id_tbl(i),
1735: PO_VAL_CONSTANTS.c_category_id_valid
1736: FROM DUAL
1737: WHERE p_order_type_lookup_code_tbl(i) NOT IN('FIXED PRICE', 'RATE')
1738: AND p_item_id_tbl(i) IS NULL
1739: AND p_category_id_tbl(i) IS NOT NULL
1740: AND NOT EXISTS(

Line 1777: FROM DUAL

1773: p_category_id_tbl(i),
1774: 'VALUE',
1775: p_category_id_tbl(i),
1776: PO_VAL_CONSTANTS.c_category_id_valid
1777: FROM DUAL
1778: WHERE p_order_type_lookup_code_tbl(i) NOT IN('FIXED PRICE', 'RATE')
1779: AND p_item_id_tbl(i) IS NULL
1780: AND p_category_id_tbl(i) IS NOT NULL
1781: AND NOT EXISTS(

Line 1875: FROM DUAL

1871: p_ip_category_id_tbl(i),
1872: 'VALUE',
1873: p_ip_category_id_tbl(i),
1874: PO_VAL_CONSTANTS.c_ip_category_id_valid
1875: FROM DUAL
1876: WHERE p_ip_category_id_tbl(i) IS NOT NULL
1877: AND p_ip_category_id_tbl(i) <> -2
1878: AND NOT EXISTS(
1879: SELECT 'Y'

Line 2008: FROM DUAL

2004: 'VALUE',
2005: 'UNIT_PRICE',
2006: X_li_unit_price,
2007: PO_VAL_CONSTANTS.c_unit_price_line_type
2008: FROM DUAL
2009: WHERE p_line_type_id_tbl(i) IS NOT NULL
2010: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
2011: AND NOT EXISTS(SELECT 1
2012: FROM po_line_types_b plt

Line 2047: FROM DUAL

2043: 'VALUE',
2044: 'UNIT_PRICE',
2045: p_unit_price_tbl(i),
2046: PO_VAL_CONSTANTS.c_unit_price_line_type
2047: FROM DUAL
2048: WHERE p_line_type_id_tbl(i) IS NOT NULL
2049: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
2050: AND NOT EXISTS(SELECT 1
2051: FROM po_line_types_b plt

Line 2353: FROM DUAL

2349: p_line_num_tbl(i),
2350: 'VALUE',
2351: p_line_num_tbl(i),
2352: PO_VAL_CONSTANTS.c_line_num_unique
2353: FROM DUAL
2354: WHERE p_po_header_id_tbl(i) IS NOT NULL
2355: AND p_line_num_tbl(i) IS NOT NULL
2356: AND (EXISTS(SELECT 'Y'
2357: FROM po_lines_all pln

Line 2441: FROM DUAL

2437: 'VALUE',
2438: p_po_line_id_tbl(i),
2439: DECODE(p_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_line_id_not_null,
2440: PO_VAL_CONSTANTS.c_po_line_id_unique)
2441: FROM DUAL
2442: WHERE p_po_line_id_tbl(i) IS NULL
2443: OR ( p_po_header_id_tbl(i) IS NOT NULL
2444: AND EXISTS(SELECT 1
2445: FROM po_lines pln

Line 2516: FROM DUAL

2512: 'VALUE',
2513: p_line_type_id_tbl(i),
2514: DECODE(p_line_type_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_line_type_id_not_null,
2515: PO_VAL_CONSTANTS.c_line_type_id_valid)
2516: FROM DUAL
2517: WHERE p_line_type_id_tbl(i) IS NULL OR
2518: NOT EXISTS(SELECT 1
2519: FROM po_line_types_val_v pltv
2520: WHERE pltv.line_type_id = p_line_type_id_tbl(i));

Line 2635: FROM DUAL

2631: p_style_id_tbl(i),
2632: 'PURCHASE_BASIS',
2633: p_purchase_basis_tbl(i),
2634: PO_VAL_CONSTANTS.c_line_style_on_purchase_basis
2635: FROM DUAL
2636: WHERE NOT EXISTS(SELECT 1
2637: FROM po_doc_style_values pdsv
2638: WHERE pdsv.style_id = p_style_id_tbl(i)
2639: AND pdsv.style_attribute_name = 'PURCHASE_BASES'

Line 2706: FROM DUAL

2702: p_price_type_lookup_code_tbl(i),
2703: 'VALUE',
2704: p_price_type_lookup_code_tbl(i),
2705: PO_VAL_CONSTANTS.c_price_type_lookup_code
2706: FROM DUAL
2707: WHERE p_price_type_lookup_code_tbl(i) IS NOT NULL
2708: AND NOT EXISTS(
2709: SELECT 'Y'
2710: FROM po_lookup_codes plc

Line 2865: FROM DUAL

2861: 'ITEM_ID',
2862: p_item_id_tbl(i),
2863: 'ITEM_ID',
2864: p_item_id_tbl(i)
2865: FROM DUAL
2866: WHERE p_item_id_tbl(i) IS NOT NULL
2867: AND p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
2868: AND EXISTS(
2869: SELECT 1

Line 3069: FROM DUAL

3065: 'PRICE_BREAK_LOOKUP_CODE',
3066: p_price_break_lookup_code_tbl(i),
3067: 'VALUE',
3068: p_price_break_lookup_code_tbl(i)
3069: FROM DUAL
3070: WHERE p_price_break_lookup_code_tbl(i) IS NOT NULL
3071: AND p_price_break_lookup_code_tbl(i) NOT IN
3072: ( SELECT lookup_code
3073: FROM po_lookup_codes PLC

Line 3258: FROM DUAL

3254: p_ip_category_id_tbl(i),
3255: 'VALUE',
3256: p_ip_category_id_tbl(i),
3257: PO_VAL_CONSTANTS.c_ip_cat_id_update_valid
3258: FROM DUAL
3259: WHERE p_ip_category_id_tbl(i) IS NOT NULL
3260: AND p_ip_category_id_tbl(i) <> -2
3261: AND NOT EXISTS(
3262: SELECT 'Y'

Line 3352: FROM DUAL

3348: p_unit_meas_lookup_code_tbl(i),
3349: 'UNIT_MEAS_LOOKUP_CODE',
3350: p_unit_meas_lookup_code_tbl(i),
3351: PO_VAL_CONSTANTS.c_uom_update_valid
3352: FROM DUAL
3353: WHERE EXISTS(
3354: SELECT 1
3355: FROM po_lines_all pol
3356: WHERE po_header_id = p_po_header_id_tbl(i) AND

Line 3462: FROM DUAL

3458: p_item_description_tbl(i),
3459: 'ITEM_DESCRIPTION',
3460: p_item_description_tbl(i),
3461: PO_VAL_CONSTANTS.c_item_desc_update_unupdatable
3462: FROM DUAL
3463: WHERE EXISTS(
3464: SELECT 1
3465: FROM mtl_system_items msi,
3466: po_lines_all pol,

Line 3687: FROM DUAL

3683: 'PO_PDOI_NO_PO_CAT_UPDATE',
3684: 'CATEGORY_ID',
3685: p_category_id_tbl(i),
3686: PO_VAL_CONSTANTS.c_cat_id_update_not_updatable
3687: FROM DUAL
3688: WHERE p_category_id_tbl(i) IS NOT NULL
3689: AND (p_item_id_tbl(i) IS NOT NULL OR p_job_id_tbl(i) IS NOT NULL)
3690: AND (EXISTS(SELECT 1
3691: FROM po_lines_all pol