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 --8688769 bug
166: ( EXISTS (SELECT 1
167: FROM po_headers_interface
168: WHERE document_num =p_document_num_tbl(i)

Line 376: FROM DUAL

372: 'VALUE',
373: p_currency_code_tbl(i),
374: DECODE(p_currency_code_tbl(i), NULL, PO_VAL_CONSTANTS.c_currency_code_not_null,
375: PO_VAL_CONSTANTS.c_currency_code_valid)
376: FROM DUAL
377: WHERE p_currency_code_tbl(i) IS NULL
378: OR NOT EXISTS(
379: SELECT 1
380: FROM fnd_currencies cur

Line 594: FROM DUAL

590: p_rate_type_tbl(i),
591: 'VALUE',
592: p_rate_type_tbl(i),
593: PO_VAL_CONSTANTS.c_rate_type_valid
594: FROM DUAL
595: WHERE p_func_currency_code <> NVL(p_currency_code_tbl(i), ' ')
596: AND p_rate_type_tbl(i) IS NOT NULL
597: AND NOT EXISTS(SELECT 1
598: FROM gl_daily_conversion_types_v dct

Line 670: FROM DUAL

666: 'VALUE',
667: p_agent_id_tbl(i),
668: DECODE(p_agent_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_agent_id_not_null,
669: PO_VAL_CONSTANTS.c_agent_id_valid)
670: FROM DUAL
671: WHERE p_agent_id_tbl(i) IS NULL
672: OR NOT EXISTS(
673: SELECT 1
674: FROM po_agents poa

Line 777: FROM DUAL

773: 'VALUE',
774: p_vendor_id_tbl(i),
775: DECODE(p_vendor_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_not_null,
776: PO_VAL_CONSTANTS.c_vendor_valid)
777: FROM DUAL
778: WHERE p_vendor_id_tbl(i) IS NULL
779: OR NOT EXISTS(SELECT 1
780: FROM po_suppliers_val_v psv
781: WHERE p_vendor_id_tbl(i) = psv.vendor_id);

Line 814: FROM DUAL

810: 'VALUE',
811: p_vendor_site_id_tbl(i),
812: DECODE(p_vendor_site_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_vendor_site_not_null,
813: PO_VAL_CONSTANTS.c_vendor_site_valid)
814: FROM DUAL
815: WHERE p_vendor_id_tbl(i) IS NOT NULL
816: AND ( p_vendor_site_id_tbl(i) IS NULL AND p_type_lookup_code_tbl(i) <> 'QUOTATION' ) /* 8913559 */
817: OR ( p_vendor_site_id_tbl(i) IS NOT NULL
818: AND NOT EXISTS(SELECT 1

Line 849: FROM DUAL

845: p_vendor_contact_id_tbl(i),
846: 'VALUE',
847: p_vendor_contact_id_tbl(i),
848: PO_VAL_CONSTANTS.c_vendor_contact_valid
849: FROM DUAL
850: WHERE p_vendor_id_tbl(i) IS NOT NULL
851: AND p_vendor_site_id_tbl(i) IS NOT NULL
852: AND p_vendor_contact_id_tbl(i) IS NOT NULL
853: AND NOT EXISTS(SELECT 1

Line 966: FROM DUAL

962: 'VALUE',
963: p_ship_to_location_id_tbl(i),
964: DECODE(p_ship_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_ship_to_location_id_not_null,
965: PO_VAL_CONSTANTS.c_ship_to_location_id_valid)
966: FROM DUAL
967: WHERE (p_ship_to_location_id_tbl(i) IS NULL
968: -- Bug 7007502: Allow bill_to_loc to be NULL for Quotations.
969: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')
970: OR (p_ship_to_location_id_tbl(i) IS NOT NULL

Line 1049: FROM DUAL

1045: 'VALUE',
1046: p_bill_to_location_id_tbl(i),
1047: DECODE(p_bill_to_location_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_bill_to_location_id_not_null,
1048: PO_VAL_CONSTANTS.c_bill_to_location_id_valid)
1049: FROM DUAL
1050: WHERE (p_bill_to_location_id_tbl(i) IS NULL
1051: -- Bug 7007502: Allow bill_to_loc to be NULL for Quotations.
1052: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')
1053: OR (p_bill_to_location_id_tbl(i) IS NOT NULL

Line 1125: FROM DUAL

1121: p_ship_via_lookup_code_tbl(i),
1122: 'VALUE',
1123: p_ship_via_lookup_code_tbl(i),
1124: PO_VAL_CONSTANTS.c_ship_via_lookup_code
1125: FROM DUAL
1126: WHERE p_ship_via_lookup_code_tbl(i) IS NOT NULL
1127: AND NOT EXISTS(
1128: SELECT 1
1129: FROM org_freight ofr

Line 1196: FROM DUAL

1192: p_fob_lookup_code_tbl(i),
1193: 'VALUE',
1194: p_fob_lookup_code_tbl(i),
1195: PO_VAL_CONSTANTS.c_fob_lookup_code
1196: FROM DUAL
1197: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
1198: AND NOT EXISTS(
1199: SELECT 1
1200: FROM po_lookup_codes plc

Line 1267: FROM DUAL

1263: p_freight_terms_lookup_tbl(i),
1264: 'VALUE',
1265: p_freight_terms_lookup_tbl(i),
1266: PO_VAL_CONSTANTS.c_freight_terms_lookup_code
1267: FROM DUAL
1268: WHERE p_freight_terms_lookup_tbl(i) IS NOT NULL
1269: AND NOT EXISTS(
1270: SELECT 1
1271: FROM po_lookup_codes plc

Line 1338: FROM DUAL

1334: p_shipping_control_tbl(i),
1335: 'VALUE',
1336: p_shipping_control_tbl(i),
1337: PO_VAL_CONSTANTS.c_shipping_control
1338: FROM DUAL
1339: WHERE p_shipping_control_tbl(i) IS NOT NULL
1340: AND NOT EXISTS(
1341: SELECT 1
1342: FROM po_lookup_codes plc

Line 1730: FROM DUAL

1726: p_style_id_tbl(i),
1727: 'STYLE_ID',
1728: p_style_id_tbl(i),
1729: PO_VAL_CONSTANTS.c_style_id_valid
1730: FROM DUAL
1731: WHERE NOT EXISTS(SELECT 1
1732: FROM po_doc_style_headers pdsh
1733: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1734: pdsh.status = 'ACTIVE');

Line 1765: FROM DUAL

1761: p_style_id_tbl(i),
1762: 'STYLE_ID',
1763: p_style_id_tbl(i),
1764: PO_VAL_CONSTANTS.c_style_id_complex_work
1765: FROM DUAL
1766: WHERE EXISTS(SELECT 1
1767: FROM po_doc_style_headers pdsh
1768: WHERE pdsh.style_id = p_style_id_tbl(i) AND
1769: pdsh.progress_payment_flag = 'Y');