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

Line 3243: -- call individual uniqueness check procedure for each unique criteria

3239:
3240: -- get key value for po_session_gt table
3241: l_key := PO_CORE_S.get_session_gt_nextval;
3242:
3243: -- call individual uniqueness check procedure for each unique criteria
3244: IF (p_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN
3245: d_position := 10;
3246:
3247: uniqueness_check_on_desc

Line 5229: -- bug 4723323: get secondary_unit_of_measure value for dual-um

5225: x_market_price_tbl.EXTEND(p_index_tbl.COUNT);
5226: x_secondary_unit_of_meas_tbl.EXTEND(p_index_tbl.COUNT);
5227:
5228: -- retrieve the values based on item id and default inv org id
5229: -- bug 4723323: get secondary_unit_of_measure value for dual-um
5230: -- control item, used in default logic
5231: FORALL i IN 1..p_index_tbl.COUNT
5232: INSERT INTO po_session_gt(key, num1, char1, char2, num2, num3,
5233: num4, num5, num6, char3)

Line 6044: FROM DUAL

6040: FORALL i IN INDICES OF l_processing_line_tbl
6041: INSERT INTO po_session_gt(key, num1)
6042: SELECT l_key,
6043: l_processing_line_tbl(i)
6044: FROM DUAL
6045: WHERE x_lines.item_id_tbl(i) IS NOT NULL
6046: AND NOT EXISTS(
6047: SELECT 1
6048: FROM po_session_gt gt

Line 6067: FROM DUAL

6063: FORALL i IN INDICES OF l_processing_line_tbl
6064: INSERT INTO po_session_gt(key, num1)
6065: SELECT l_key,
6066: l_processing_line_tbl(i)
6067: FROM DUAL
6068: WHERE x_lines.item_id_tbl(i) IS NULL
6069: AND NOT EXISTS(
6070: SELECT 1
6071: FROM po_session_gt gt

Line 6600: FROM DUAL;

6596: x_lines.intf_line_id_tbl(i), -- num1
6597: x_lines.hd_po_header_id_tbl(i), -- num2
6598: x_lines.item_desc_tbl(i), -- char1
6599: x_lines.category_tbl(i) -- char2
6600: FROM DUAL;
6601:
6602: d_position := 40;
6603:
6604: FORALL i IN INDICES OF x_processing_row_tbl

Line 6612: FROM DUAL

6608: num1
6609: )
6610: SELECT p_key,
6611: x_processing_row_tbl(i)
6612: FROM DUAL
6613: WHERE NOT EXISTS(
6614: SELECT 1
6615: FROM po_session_gt gt
6616: WHERE key = l_data_key

Line 6894: FROM DUAL;

6890: x_lines.item_tbl(i), -- char1
6891: x_lines.item_revision_tbl(i), -- char2
6892: x_lines.vendor_product_num_tbl(i), -- char3
6893: x_lines.supplier_part_auxid_tbl(i) -- char4
6894: FROM DUAL;
6895:
6896: d_position := 40;
6897:
6898: -- bug4930510

Line 6909: FROM DUAL

6905: num1
6906: )
6907: SELECT p_key,
6908: x_processing_row_tbl(i)
6909: FROM DUAL
6910: WHERE x_lines.item_tbl(i) IS NOT NULL
6911: AND NOT EXISTS(
6912: SELECT 1
6913: FROM po_session_gt gt

Line 7156: FROM DUAL;

7152: x_lines.intf_line_id_tbl(i), -- num1
7153: x_lines.hd_po_header_id_tbl(i), -- num2
7154: x_lines.vendor_product_num_tbl(i), -- char1
7155: x_lines.supplier_part_auxid_tbl(i) -- char2
7156: FROM DUAL;
7157:
7158: d_position := 40;
7159:
7160: FORALL i IN INDICES OF x_processing_row_tbl

Line 7168: FROM DUAL

7164: num1
7165: )
7166: SELECT p_key,
7167: x_processing_row_tbl(i)
7168: FROM DUAL
7169: WHERE x_lines.item_tbl(i) IS NULL
7170: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
7171: AND NOT EXISTS(
7172: SELECT 1

Line 7415: FROM DUAL;

7411: l_data_key,
7412: x_lines.intf_line_id_tbl(i), -- num1
7413: x_lines.hd_po_header_id_tbl(i), -- num2
7414: x_lines.job_name_tbl(i) -- char1
7415: FROM DUAL;
7416:
7417: d_position := 40;
7418:
7419: FORALL i IN INDICES OF x_processing_row_tbl

Line 7427: FROM DUAL

7423: num1
7424: )
7425: SELECT p_key,
7426: x_processing_row_tbl(i)
7427: FROM DUAL
7428: WHERE x_lines.item_tbl(i) IS NULL
7429: AND x_lines.vendor_product_num_tbl(i) IS NULL
7430: AND x_lines.job_name_tbl(i) IS NOT NULL
7431: AND NOT EXISTS(

Line 7625: FROM DUAL;

7621: l_data_key,
7622: x_lines.intf_line_id_tbl(i), -- num1
7623: x_lines.hd_po_header_id_tbl(i), -- num2
7624: x_lines.line_num_tbl(i) -- num3
7625: FROM DUAL;
7626:
7627: d_position := 40;
7628:
7629: FORALL i IN INDICES OF x_processing_row_tbl

Line 7637: FROM DUAL

7633: num1
7634: )
7635: SELECT p_key,
7636: x_processing_row_tbl(i)
7637: FROM DUAL
7638: WHERE x_lines.item_tbl(i) IS NULL
7639: AND x_lines.vendor_product_num_tbl(i) IS NULL
7640: AND x_lines.job_name_tbl(i) IS NULL
7641: AND x_lines.line_num_tbl(i) IS NOT NULL

Line 7861: FROM DUAL

7857: )
7858: SELECT
7859: l_key,
7860: l_index_tbl(i)
7861: FROM DUAL
7862: WHERE NOT EXISTS
7863: (
7864: SELECT 1
7865: FROM po_attr_values_tlp_interface