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

Line 82: FROM DUAL

78: 'VALUE',
79: p_po_header_id_tbl(i),
80: DECODE(p_po_header_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_header_id_not_null,
81: PO_VAL_CONSTANTS.c_po_header_id_unique)
82: FROM DUAL
83: WHERE p_id_tbl(i) IS NULL OR EXISTS(SELECT 1
84: FROM po_headers_all poh
85: WHERE p_po_header_id_tbl(i) = poh.po_header_id);
86:

Line 164: FROM DUAL

160: p_document_num_tbl(i),
161: 'VALUE',
162: p_document_num_tbl(i),
163: PO_VAL_CONSTANTS.c_document_num_unique
164: FROM DUAL
165: WHERE p_document_num_tbl(i) IS NOT NULL AND
166: EXISTS(SELECT 1
167: FROM po_headers
168: WHERE segment1 = p_document_num_tbl(i)

Line 369: FROM DUAL

365: 'VALUE',
366: p_currency_code_tbl(i),
367: DECODE(p_currency_code_tbl(i), NULL, PO_VAL_CONSTANTS.c_currency_code_not_null,
368: PO_VAL_CONSTANTS.c_currency_code_valid)
369: FROM DUAL
370: WHERE p_currency_code_tbl(i) IS NULL
371: OR NOT EXISTS(
372: SELECT 1
373: FROM fnd_currencies cur

Line 587: FROM DUAL

583: p_rate_type_tbl(i),
584: 'VALUE',
585: p_rate_type_tbl(i),
586: PO_VAL_CONSTANTS.c_rate_type_valid
587: FROM DUAL
588: WHERE p_func_currency_code <> NVL(p_currency_code_tbl(i), ' ')
589: AND p_rate_type_tbl(i) IS NOT NULL
590: AND NOT EXISTS(SELECT 1
591: FROM gl_daily_conversion_types_v dct

Line 663: FROM DUAL

659: 'VALUE',
660: p_agent_id_tbl(i),
661: DECODE(p_agent_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_agent_id_not_null,
662: PO_VAL_CONSTANTS.c_agent_id_valid)
663: FROM DUAL
664: WHERE p_agent_id_tbl(i) IS NULL
665: OR NOT EXISTS(
666: SELECT 1
667: FROM po_agents poa

Line 768: FROM DUAL

764: 'VALUE',
765: p_vendor_id_tbl(i),
766: DECODE(p_vendor_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_not_null,
767: PO_VAL_CONSTANTS.c_vendor_valid)
768: FROM DUAL
769: WHERE p_vendor_id_tbl(i) IS NULL
770: OR NOT EXISTS(SELECT 1
771: FROM po_suppliers_val_v psv
772: WHERE p_vendor_id_tbl(i) = psv.vendor_id);

Line 805: FROM DUAL

801: 'VALUE',
802: p_vendor_site_id_tbl(i),
803: DECODE(p_vendor_site_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_site_not_null,
804: PO_VAL_CONSTANTS.c_vendor_site_valid)
805: FROM DUAL
806: WHERE p_vendor_id_tbl(i) IS NOT NULL
807: AND ( p_vendor_site_id_tbl(i) IS NULL
808: OR NOT EXISTS(SELECT 1
809: FROM po_supplier_sites_val_v pssv

Line 839: FROM DUAL

835: p_vendor_contact_id_tbl(i),
836: 'VALUE',
837: p_vendor_contact_id_tbl(i),
838: PO_VAL_CONSTANTS.c_vendor_contact_valid
839: FROM DUAL
840: WHERE p_vendor_id_tbl(i) IS NOT NULL
841: AND p_vendor_site_id_tbl(i) IS NOT NULL
842: AND p_vendor_contact_id_tbl(i) IS NOT NULL
843: AND NOT EXISTS(SELECT 1

Line 956: FROM DUAL

952: 'VALUE',
953: p_ship_to_location_id_tbl(i),
954: DECODE(p_ship_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_ship_to_location_id_not_null,
955: PO_VAL_CONSTANTS.c_ship_to_location_id_valid)
956: FROM DUAL
957: WHERE (p_ship_to_location_id_tbl(i) IS NULL
958: -- Bug 7007502: Allow bill_to_loc to be NULL for Quotations.
959: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')
960: OR (p_ship_to_location_id_tbl(i) IS NOT NULL

Line 1039: FROM DUAL

1035: 'VALUE',
1036: p_bill_to_location_id_tbl(i),
1037: DECODE(p_bill_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_bill_to_location_id_not_null,
1038: PO_VAL_CONSTANTS.c_bill_to_location_id_valid)
1039: FROM DUAL
1040: WHERE (p_bill_to_location_id_tbl(i) IS NULL
1041: -- Bug 7007502: Allow bill_to_loc to be NULL for Quotations.
1042: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')
1043: OR (p_bill_to_location_id_tbl(i) IS NOT NULL

Line 1115: FROM DUAL

1111: p_ship_via_lookup_code_tbl(i),
1112: 'VALUE',
1113: p_ship_via_lookup_code_tbl(i),
1114: PO_VAL_CONSTANTS.c_ship_via_lookup_code
1115: FROM DUAL
1116: WHERE p_ship_via_lookup_code_tbl(i) IS NOT NULL
1117: AND NOT EXISTS(
1118: SELECT 1
1119: FROM org_freight ofr

Line 1186: FROM DUAL

1182: p_fob_lookup_code_tbl(i),
1183: 'VALUE',
1184: p_fob_lookup_code_tbl(i),
1185: PO_VAL_CONSTANTS.c_fob_lookup_code
1186: FROM DUAL
1187: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
1188: AND NOT EXISTS(
1189: SELECT 1
1190: FROM po_lookup_codes plc

Line 1257: FROM DUAL

1253: p_freight_terms_lookup_tbl(i),
1254: 'VALUE',
1255: p_freight_terms_lookup_tbl(i),
1256: PO_VAL_CONSTANTS.c_freight_terms_lookup_code
1257: FROM DUAL
1258: WHERE p_freight_terms_lookup_tbl(i) IS NOT NULL
1259: AND NOT EXISTS(
1260: SELECT 1
1261: FROM po_lookup_codes plc

Line 1328: FROM DUAL

1324: p_shipping_control_tbl(i),
1325: 'VALUE',
1326: p_shipping_control_tbl(i),
1327: PO_VAL_CONSTANTS.c_shipping_control
1328: FROM DUAL
1329: WHERE p_shipping_control_tbl(i) IS NOT NULL
1330: AND NOT EXISTS(
1331: SELECT 1
1332: FROM po_lookup_codes plc

Line 1720: FROM DUAL

1716: p_style_id_tbl(i),
1717: 'STYLE_ID',
1718: p_style_id_tbl(i),
1719: PO_VAL_CONSTANTS.c_style_id_valid
1720: FROM DUAL
1721: WHERE NOT EXISTS(SELECT 1
1722: FROM po_doc_style_headers pdsh
1723: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1724: pdsh.status = 'ACTIVE');

Line 1753: FROM DUAL

1749: p_style_id_tbl(i),
1750: 'STYLE_ID',
1751: p_style_id_tbl(i),
1752: PO_VAL_CONSTANTS.c_style_id_complex_work
1753: FROM DUAL
1754: WHERE EXISTS(SELECT 1
1755: FROM po_doc_style_headers pdsh
1756: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1757: pdsh.progress_payment_flag = 'Y');