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

Line 738: FROM DUAL

734: , p_header_id_tbl(i)
735: , c_START_DATE
736: , TO_CHAR(p_start_date_tbl(i))
737: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR
738: FROM DUAL
739: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
740: AND EXISTS
741: (
742: SELECT NULL

Line 821: FROM DUAL

817: , p_header_id_tbl(i)
818: , c_START_DATE
819: , TO_CHAR(p_start_date_tbl(i))
820: , PO_MESSAGE_S.PO_IDV_EFF_DT_LT_ORD_ST_DT_CLM
821: FROM DUAL
822: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
823: AND p_start_date_tbl(i) < p_clm_effective_date_tbl(i);
824:
825: IF (SQL%ROWCOUNT > 0) THEN

Line 895: FROM DUAL

891: , p_header_id_tbl(i)
892: , c_AMOUNT_LIMIT
893: , TO_CHAR(p_amount_limit_tbl(i))
894: , PO_MESSAGE_S.PO_IDV_MX_CL_AMT_GT_RLSD_CLM
895: FROM DUAL
896: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
897: AND p_amount_limit_tbl(i) < p_min_grnt_awd_amt_tbl(i);
898:
899: IF (SQL%ROWCOUNT > 0) THEN

Line 969: FROM DUAL

965: , p_header_id_tbl(i)
966: , c_AMOUNT_LIMIT
967: , TO_CHAR(p_amount_limit_tbl(i))
968: , PO_MESSAGE_S.PO_IDV_MX_CL_AMT_GT_MNPM_CLM
969: FROM DUAL
970: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
971: AND p_amount_limit_tbl(i) < p_min_order_amt_tbl(i);
972:
973: IF (SQL%ROWCOUNT > 0) THEN

Line 1042: FROM DUAL

1038: , p_header_id_tbl(i)
1039: , c_AMOUNT_LIMIT
1040: , TO_CHAR(p_amount_limit_tbl(i))
1041: , PO_MESSAGE_S.PO_IDV_MX_CL_AMT_GT_MXPM_CLM
1042: FROM DUAL
1043: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
1044: AND p_amount_limit_tbl(i) < p_max_order_amt_tbl(i);
1045:
1046: IF (SQL%ROWCOUNT > 0) THEN

Line 1154: FROM DUAL

1150: , p_header_id_tbl(i)
1151: , c_CLM_MAX_ORD_AMT
1152: , TO_CHAR(p_max_order_amt_tbl(i))
1153: , PO_MESSAGE_S.PO_IDV_MX_OD_AMT_GT_MN_OD_CLM
1154: FROM DUAL
1155: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
1156: AND p_max_order_amt_tbl(i) < p_min_order_amt_tbl(i);
1157:
1158: IF (SQL%ROWCOUNT > 0) THEN

Line 1311: FROM DUAL

1307: , p_header_id_tbl(i)
1308: , c_END_DATE
1309: , TO_CHAR(p_end_date_tbl(i))
1310: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR
1311: FROM DUAL
1312: WHERE
1313: p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
1314: AND EXISTS
1315: ( SELECT NULL

Line 1395: FROM DUAL

1391: , p_header_id_tbl(i)
1392: , c_START_DATE
1393: , TO_CHAR(p_start_date_tbl(i))
1394: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR
1395: FROM DUAL
1396: WHERE
1397: p_type_lookup_code_tbl(i) = c_CONTRACT
1398: AND EXISTS
1399: ( SELECT NULL

Line 1479: FROM DUAL

1475: , p_header_id_tbl(i)
1476: , c_END_DATE
1477: , TO_CHAR(p_end_date_tbl(i))
1478: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR
1479: FROM DUAL
1480: WHERE
1481: p_type_lookup_code_tbl(i) = c_CONTRACT
1482: AND EXISTS
1483: ( SELECT NULL

Line 2376: FROM dual

2372: p_ship_via_lookup_code_tbl(i),
2373: 'VALUE',
2374: p_ship_via_lookup_code_tbl(i),
2375: PO_VAL_CONSTANTS.c_ship_via_lookup_code
2376: FROM dual
2377: WHERE NOT EXISTS (SELECT 1 FROM org_freight ofr
2378: WHERE p_ship_via_lookup_code_tbl(i) = ofr.freight_code
2379: AND SYSDATE < NVL(ofr.disable_date, SYSDATE + 1)
2380: --Bug 12409257 start

Line 2453: FROM DUAL

2449: ,p_header_id_tbl(i)
2450: ,PO_MESSAGE_S.PO_MOD_EFFECT_DT_INVALID
2451: ,c_MOD_EFFECTIVE_DATE
2452: ,TO_CHAR(p_mod_eff_date_tbl(i))
2453: FROM DUAL
2454: WHERE p_mod_eff_date_tbl(i) is not NULL
2455: AND p_mod_eff_date_tbl(i) > (
2456: SELECT min(nvl(need_by_date, p_mod_eff_date_tbl(i)+1))
2457: FROM PO_LINE_LOCATIONS_ALL

Line 2518: FROM DUAL

2514: c_entity_type_HEADER
2515: ,p_header_id_tbl(i)
2516: ,PO_MESSAGE_S.PO_MOD_EFFECT_DT_NOTNULL
2517: ,c_MOD_EFFECTIVE_DATE
2518: FROM DUAL
2519: WHERE p_mod_eff_date_tbl(i) is NULL
2520: AND nvl(p_draft_type_tbl(i), '*') = 'MOD';
2521:
2522: IF (SQL%ROWCOUNT > 0) THEN

Line 2577: FROM DUAL

2573: ,p_header_id_tbl(i)
2574: ,PO_MESSAGE_S.PO_MOD_CANCEL_INVALID
2575: ,c_CONTROL_ACTION
2576: ,TO_CHAR(p_control_action_tbl(i))
2577: FROM DUAL
2578: WHERE nvl(p_control_action_tbl(i), '*') = 'CANCEL'
2579: AND not exists
2580: (SELECT 'Y'
2581: FROM PO_LINE_LOCATIONS_ALL

Line 2639: FROM dual

2635: IF p_clm_standard_form_tbl(i) IS NOT NULL
2636: THEN
2637: BEGIN
2638: SELECT 'Y' INTO l_valid_standard_form
2639: FROM dual
2640: WHERE p_clm_standard_form_tbl(i) IN ( SELECT DISTINCT standard_form
2641: FROM PO_PRINT_FORM_FORMATS
2642: WHERE style_id = p_style_id_tbl(i)
2643: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,

Line 2718: FROM dual

2714: l_results_count := l_results_count + 1;
2715: ELSE
2716: BEGIN
2717: SELECT 'Y' INTO l_valid_document_format
2718: FROM dual
2719: WHERE p_clm_document_format_tbl(i) IN ( SELECT document_format
2720: FROM PO_PRINT_FORM_FORMATS
2721: WHERE style_id = p_style_id_tbl(i)
2722: AND standard_form = p_clm_standard_form_tbl(i)

Line 2791: FROM dual

2787: THEN
2788: BEGIN
2789:
2790: SELECT 'Y' INTO is_valid_src_doc_id
2791: FROM dual
2792: WHERE EXISTS (
2793: select poh.po_header_id
2794: FROM po_headers_all POH,
2795: hr_all_organization_units_tl HOUTL,

Line 2894: FROM dual

2890: IF p_award_admin_tbl(i) IS NOT NULL
2891: THEN
2892: BEGIN
2893: SELECT 'Y' INTO is_valid_award_admin
2894: FROM dual
2895: WHERE EXISTS (
2896: SELECT FULL_NAME
2897: FROM
2898: PO_BUYERS_VAL_V

Line 2962: FROM dual

2958: IF p_contract_officer_tbl(i) IS NOT NULL
2959: THEN
2960: BEGIN
2961: SELECT 'Y' INTO is_valid_contract_officer
2962: FROM dual
2963: WHERE EXISTS (
2964: SELECT FULL_NAME
2965: FROM
2966: PO_BUYERS_VAL_V

Line 3033: FROM dual

3029: (p_src_doc_id_tbl(i) IS NOT NULL)
3030: THEN
3031: BEGIN
3032: SELECT 'Y' INTO is_valid_umbrella_prg_id
3033: FROM dual
3034: WHERE p_umbrella_program_id_tbl(i) = (
3035: SELECT Nvl(umbrella_program_id,-1)
3036: FROM po_headers_all
3037: WHERE po_header_id = p_src_doc_id_tbl(i)

Line 3106: FROM dual

3102: IF p_type_lookup_code_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
3103: THEN
3104: BEGIN
3105: SELECT 'Y' INTO is_valid_awd_type
3106: FROM dual
3107: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes
3108: WHERE lookup_type IN ('PO_CLM_AWD_TYPE_SPO',
3109: 'PO_CLM_AWD_TYPE_ORD_OFF_IDV'
3110: )

Line 3128: FROM dual

3124: PO_PDOI_CONSTANTS.g_DOC_TYPE_CONTRACT)
3125: THEN
3126: BEGIN
3127: SELECT 'Y' INTO is_valid_awd_type
3128: FROM dual
3129: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes
3130: WHERE lookup_type = Decode(p_type_lookup_code_tbl(i),
3131: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,'PO_CLM_AWD_TYPE_BPA',
3132: PO_PDOI_CONSTANTS.g_DOC_TYPE_CONTRACT,'PO_CLM_AWD_TYPE_CPA')

Line 3211: FROM dual

3207: INSERT INTO po_session_gt(KEY,num1,num2)
3208: SELECT l_data_key,
3209: p_intf_header_id(i),
3210: p_style_id_tbl(i)
3211: FROM dual
3212: WHERE p_style_id_tbl(i) IS NULL
3213: OR p_style_id_tbl(i) NOT IN ( SELECT column_value FROM TABLE(l_clm_style_id_tbl) );
3214:
3215: DELETE FROM po_session_gt