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_R12_CAT_UPG_VAL_PVT dependencies on DUAL

Line 524: FROM DUAL

520: SELECT p_key
521: , l_subscript_array(i)
522: , p_headers_rec.interface_header_id(i)
523: , p_headers_rec.currency_code(i)
524: FROM DUAL
525: WHERE --p_headers_rec.has_errors(i) = 'N'
526: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
527: -- ECO bug 5584556: Start
528: -- The following validation check is already done above.

Line 674: FROM DUAL

670: , l_subscript_array(i)
671: , p_headers_rec.interface_header_id(i)
672: , p_headers_rec.vendor_id(i)
673: , p_headers_rec.vendor_name(i)
674: FROM DUAL
675: WHERE --p_headers_rec.has_errors(i) = 'N'
676: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
677: AND (p_headers_rec.vendor_id(i) IS NULL
678: OR p_headers_rec.vendor_id(i) = g_NULL_COLUMN_VALUE -- -2

Line 734: FROM DUAL

730: , l_subscript_array(i)
731: , p_headers_rec.interface_header_id(i)
732: , p_headers_rec.vendor_id(i)
733: , p_headers_rec.vendor_name(i)
734: FROM DUAL
735: WHERE --p_headers_rec.has_errors(i) = 'N'
736: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
737: -- ECO bug 5584556: Start
738: -- The following 3 validation checks are already done above.

Line 809: FROM DUAL

805: , l_subscript_array(i)
806: , p_headers_rec.interface_header_id(i)
807: , p_headers_rec.vendor_site_id(i)
808: , p_headers_rec.vendor_site_code(i)
809: FROM DUAL
810: WHERE --p_headers_rec.has_errors(i) = 'N'
811: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE')
812: AND
813: (

Line 883: FROM DUAL

879: , l_subscript_array(i)
880: , p_headers_rec.interface_header_id(i)
881: , p_headers_rec.vendor_site_id(i)
882: , p_headers_rec.vendor_site_code(i)
883: FROM DUAL
884: WHERE --p_headers_rec.has_errors(i) = 'N'
885: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE')
886: -- ECO bug 5584556: Start
887: -- The following 3 validation checks are already done above.

Line 955: FROM DUAL

951: SELECT p_key
952: , l_subscript_array(i)
953: , p_headers_rec.interface_header_id(i)
954: , p_headers_rec.vendor_contact_id(i)
955: FROM DUAL
956: WHERE --p_headers_rec.has_errors(i) = 'N'
957: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE')
958: AND p_headers_rec.vendor_id(i) IS NOT NULL
959: AND p_headers_rec.vendor_site_id(i) IS NOT NULL

Line 1206: FROM DUAL

1202: SELECT p_key
1203: , l_subscript_array(i)
1204: , p_headers_rec.interface_header_id(i)
1205: , p_headers_rec.ship_to_location_id(i)
1206: FROM DUAL
1207: WHERE --p_headers_rec.has_errors(i) = 'N'
1208: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1209: AND (p_headers_rec.ship_to_location_id(i) IS NULL OR
1210: NOT EXISTS(SELECT 1

Line 1262: FROM DUAL

1258: SELECT p_key
1259: , l_subscript_array(i)
1260: , p_headers_rec.interface_header_id(i)
1261: , p_headers_rec.ship_to_location_id(i)
1262: FROM DUAL
1263: WHERE --p_headers_rec.has_errors(i) = 'N'
1264: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1265: -- ECO bug 5584556: Start
1266: -- The following validation checks are already done above.

Line 1401: FROM DUAL

1397: SELECT p_key
1398: , l_subscript_array(i)
1399: , p_headers_rec.interface_header_id(i)
1400: , p_headers_rec.bill_to_location_id(i)
1401: FROM DUAL
1402: WHERE --p_headers_rec.has_errors(i) = 'N'
1403: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1404: AND (p_headers_rec.bill_to_location_id(i) IS NULL OR
1405: NOT EXISTS(SELECT 1

Line 1456: FROM DUAL

1452: SELECT p_key
1453: , l_subscript_array(i)
1454: , p_headers_rec.interface_header_id(i)
1455: , p_headers_rec.bill_to_location_id(i)
1456: FROM DUAL
1457: WHERE --p_headers_rec.has_errors(i) = 'N'
1458: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1459: -- ECO bug 5584556: Start
1460: -- The following validation checks are already done above.

Line 1667: FROM DUAL

1663: SELECT p_key
1664: , l_subscript_array(i)
1665: , p_headers_rec.interface_header_id(i)
1666: , p_headers_rec.fob(i)
1667: FROM DUAL
1668: WHERE --p_headers_rec.has_errors(i) = 'N'
1669: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1670: AND p_headers_rec.fob(i) IS NOT NULL
1671: AND NOT EXISTS(SELECT 1

Line 1803: FROM DUAL

1799: SELECT p_key
1800: , l_subscript_array(i)
1801: , p_headers_rec.interface_header_id(i)
1802: , p_headers_rec.freight_carrier(i)
1803: FROM DUAL
1804: WHERE --p_headers_rec.has_errors(i) = 'N'
1805: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1806: AND p_headers_rec.freight_carrier(i) IS NOT NULL
1807: AND NOT EXISTS(SELECT 1

Line 1926: FROM DUAL

1922: SELECT p_key
1923: , l_subscript_array(i)
1924: , p_headers_rec.interface_header_id(i)
1925: , p_headers_rec.freight_terms(i)
1926: FROM DUAL
1927: WHERE --p_headers_rec.has_errors(i) = 'N'
1928: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1929: AND p_headers_rec.freight_terms(i) IS NOT NULL
1930: AND NOT EXISTS(

Line 2127: FROM DUAL

2123: SELECT p_key
2124: , l_subscript_array(i)
2125: , p_headers_rec.interface_header_id(i)
2126: , p_headers_rec.terms_id(i)
2127: FROM DUAL
2128: WHERE --p_headers_rec.has_errors(i) = 'N'
2129: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
2130: AND p_headers_rec.terms_id(i) IS NOT NULL
2131: AND NOT EXISTS

Line 2263: FROM DUAL

2259: SELECT p_key
2260: , l_subscript_array(i)
2261: , p_headers_rec.interface_header_id(i)
2262: , p_headers_rec.shipping_control(i)
2263: FROM DUAL
2264: WHERE --p_headers_rec.has_errors(i) = 'N'
2265: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
2266: AND p_headers_rec.shipping_control(i) IS NOT NULL
2267: AND NOT EXISTS(

Line 2422: FROM DUAL

2418: SELECT p_key
2419: , l_subscript_array(i)
2420: , p_headers_rec.interface_header_id(i)
2421: , p_headers_rec.rate_type_code(i)
2422: FROM DUAL
2423: WHERE --p_headers_rec.has_errors(i) = 'N'
2424: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
2425: AND p_headers_rec.currency_code(i) <> PO_R12_CAT_UPG_PVT.g_sys.currency_code
2426: AND p_headers_rec.rate_type_code(i) IS NOT NULL

Line 2528: FROM DUAL;

2524:
2525: -- pick a new key from temp table which will be used in all validate logic
2526: SELECT PO_SESSION_GT_S.nextval
2527: INTO l_key
2528: FROM DUAL;
2529:
2530: l_progress := '020';
2531: -- validate that agent_id is not null
2532: validate_buyer

Line 2838: FROM DUAL

2834: , l_subscript_array(i)
2835: , p_lines_rec.interface_header_id(i)
2836: , p_lines_rec.interface_line_id(i)
2837: , p_lines_rec.item_description(i)
2838: FROM DUAL
2839: WHERE --p_lines_rec.has_errors(i) = 'N'
2840: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
2841: AND (p_lines_rec.item_description(i) is null OR
2842: (p_lines_rec.item_id(i) is not null AND

Line 3090: FROM DUAL

3086: , p_lines_rec.interface_header_id(i)
3087: , p_lines_rec.interface_line_id(i)
3088: , p_lines_rec.unit_of_measure(i)
3089: , p_lines_rec.uom_code(i)
3090: FROM DUAL
3091: WHERE --p_lines_rec.has_errors(i) = 'N'
3092: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3093: AND p_lines_rec.unit_of_measure(i) is not null
3094: AND p_lines_rec.uom_code(i) is not null

Line 3256: FROM DUAL

3252: , p_lines_rec.interface_header_id(i)
3253: , p_lines_rec.interface_line_id(i)
3254: , p_lines_rec.item_id(i)
3255: , p_lines_rec.item_revision(i)
3256: FROM DUAL
3257: WHERE --p_lines_rec.has_errors(i) = 'N'
3258: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3259: AND p_lines_rec.item_revision(i) is not null
3260: AND p_lines_rec.item_id(i) is not null

Line 3632: FROM DUAL

3628: , p_lines_rec.interface_line_id(i)
3629: , p_lines_rec.item_id(i)
3630: , p_lines_rec.category_id(i)
3631: , p_lines_rec.category(i) -- category name
3632: FROM DUAL
3633: WHERE --p_lines_rec.has_errors(i) = 'N'
3634: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3635: AND p_lines_rec.item_id(i) is not null
3636: AND p_lines_rec.category_id(i) is not null

Line 3722: FROM DUAL

3718: , p_lines_rec.interface_header_id(i)
3719: , p_lines_rec.interface_line_id(i)
3720: , p_lines_rec.category_id(i)
3721: , p_lines_rec.category(i) -- category name
3722: FROM DUAL
3723: WHERE --p_lines_rec.has_errors(i) = 'N'
3724: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3725: AND p_lines_rec.item_id(i) is null
3726: AND p_lines_rec.category_id(i) is not null

Line 3810: FROM DUAL

3806: , p_lines_rec.interface_header_id(i)
3807: , p_lines_rec.interface_line_id(i)
3808: , p_lines_rec.category_id(i)
3809: , p_lines_rec.category(i) -- category name
3810: FROM DUAL
3811: WHERE --p_lines_rec.has_errors(i) = 'N'
3812: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3813: AND p_lines_rec.item_id(i) is null
3814: AND p_lines_rec.category_id(i) is not null

Line 4026: FROM DUAL;

4022:
4023: -- pick a new key from temp table which will be used in all validate logic
4024: SELECT PO_SESSION_GT_S.nextval
4025: INTO l_key
4026: FROM DUAL;
4027:
4028: l_progress := '020';
4029: -- if item id is not null, it has to exist in mtl_system_items table
4030: validate_item