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

Line 643: DUAL

639: -- PBWC Message Change Impact: Adding a token
640: , p_token1_name
641: , to_char(p_token1_value(i))
642: FROM
643: DUAL
644: WHERE NOT EXISTS
645: ( SELECT null
646: FROM
647: GL_PERIOD_STATUSES PO_PERIOD

Line 1867: USING DUAL

1863: -- Merge in the new data.
1864:
1865: FORALL i IN 1 .. p_entity_id_tbl.COUNT
1866: MERGE INTO PO_SESSION_GT SES
1867: USING DUAL
1868: ON
1869: ( SES.key = l_data_key
1870: AND SES.index_num2 = p_entity_id_tbl(i)
1871: )

Line 2060: USING DUAL

2056: -- Merge in the new data.
2057:
2058: FORALL i IN 1 .. p_price_diff_id_tbl.COUNT
2059: MERGE INTO PO_SESSION_GT SES
2060: USING DUAL
2061: ON
2062: ( SES.key = l_data_key
2063: AND SES.index_num2 = p_price_diff_id_tbl(i)
2064: )

Line 2506: FROM DUAL

2502: p_terms_id_tbl(i),
2503: 'VALUE',
2504: p_terms_id_tbl(i),
2505: p_validation_id
2506: FROM DUAL
2507: WHERE p_terms_id_tbl(i) IS NOT NULL
2508: AND NOT EXISTS
2509: (SELECT 1
2510: FROM AP_TERMS APT

Line 2548: -- The check is only performed for opm dual uom items

2544: --Locks: None.
2545: --Function:
2546: -- Checks that each value is greater than zero and not null,
2547: -- and adds an error to x_results if it is not.
2548: -- The check is only performed for opm dual uom items
2549: --Parameters:
2550: --IN:
2551: --p_calling_module
2552: -- The module base of the calling procedure, used for logging.

Line 2703: -- Determines if the item is opm dual uom contrilled item

2699: -- primary uom
2700: --p_secondary_uom_tbl
2701: -- Secondary uom
2702: --p_sec_default_ind_tbl
2703: -- Determines if the item is opm dual uom contrilled item
2704: --p_column_name
2705: --IN OUT:
2706: --x_results
2707: -- Validation errors will be added to this object.

Line 2783: -- Call the INV API to validate dual quantities

2779:
2780: IF l_sec_default_ind IS NOT NULL AND p_quantity_tbl(i) IS NOT NULL AND
2781: p_sec_quantity_tbl(i) IS NOT NULL
2782: THEN
2783: -- Call the INV API to validate dual quantities
2784: PO_INV_INTEGRATION_GRP.within_deviation(
2785: p_api_version => 1.0,
2786: p_organization_id => p_inv_org_id_tbl(i),
2787: p_item_id => p_item_id_tbl(i),

Line 2906: -- Item is not dual control

2902: END IF;
2903:
2904: IF l_secondary_unit_of_meas_tbl(i) IS NULL THEN
2905: IF (p_secondary_unit_of_meas_tbl(i) IS NOT NULL) THEN
2906: -- Item is not dual control
2907: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2908: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2909: ELSE
2910: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;

Line 2922: -- Secondary UOM missing for dual control item

2918: x_result_type := po_validations.c_result_type_failure;
2919: END IF;
2920: ELSE -- l_secondary_unit_of_measure is not null
2921: IF p_secondary_unit_of_meas_tbl(i) IS NULL THEN
2922: -- Secondary UOM missing for dual control item
2923: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2924: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;
2925: ELSE
2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;

Line 3109: -- Item is not dual control

3105:
3106: d_position := 60;
3107:
3108: IF p_secondary_quantity_tbl(i) IS NOT NULL AND p_doc_type IN ('STANDARD', 'BLANKET') THEN
3109: -- Item is not dual control
3110: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3111: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;
3112: ELSE
3113: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;

Line 3128: -- Secondary Quantity missing for dual control item

3124:
3125: d_position := 70;
3126:
3127: IF p_secondary_quantity_tbl(i) IS NULL AND p_doc_type='STANDARD' THEN
3128: -- Secondary Quantity missing for dual control item
3129: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3130: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;
3131: ELSE
3132: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;

Line 3224: FROM DUAL

3220: 'ITEM',
3221: 'SECONDARY_UNIT_OF_MEASURE',
3222: p_secondary_unit_of_meas_tbl(i),
3223: p_item_id_tbl(i)
3224: FROM DUAL
3225: WHERE p_item_id_tbl(i) IS NOT NULL
3226: AND p_organization_id_tbl(i) IS NOT NULL
3227: AND p_secondary_unit_of_meas_tbl(i) IS NOT NULL
3228: AND EXISTS(

Line 3340: FROM DUAL

3336: p_preferred_grade_tbl(i),
3337: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3338: PO_VAL_CONSTANTS.c_line_preferred_grade_item,
3339: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)
3340: FROM DUAL
3341: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3342: AND p_item_id_tbl(i) IS NOT NULL
3343: AND EXISTS(
3344: SELECT 1

Line 3374: FROM DUAL

3370: p_preferred_grade_tbl(i),
3371: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3372: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,
3373: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)
3374: FROM DUAL
3375: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3376: AND NOT EXISTS(
3377: SELECT 1
3378: FROM mtl_grades_b mgb

Line 3444: FROM DUAL

3440: p_id_tbl(i),
3441: 'PO_OPS_ITEM_PROCESS_ORG',
3442: 'SHIP_TO_ORGANIZATION_ID',
3443: p_ship_to_organization_id_tbl(i)
3444: FROM DUAL
3445: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
3446: AND p_item_id_tbl(i) IS NOT NULL
3447: AND EXISTS(
3448: SELECT 1

Line 3674: select REGEXP_SUBSTR(p_par_draft_id ,'[^,]+', 1, LEVEL) l_par_draft_id FROM dual

3670:
3671: l_par_draft_id_tbl := po_tbl_number();
3672: FOR context_cur IN
3673: (
3674: select REGEXP_SUBSTR(p_par_draft_id ,'[^,]+', 1, LEVEL) l_par_draft_id FROM dual
3675: CONNECT BY regexp_substr(p_par_draft_id, '[^,]+', 1, LEVEL) IS NOT NULL
3676: ) LOOP
3677:
3678: IF context_cur.l_par_draft_id IS NOT NULL THEN