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

Line 1827: FROM dual;

1823:
1824: l_progress := '050';
1825: SELECT PO_HEADERS_S.nextval
1826: INTO l_valid_headers.po_header_id(l_count)
1827: FROM dual;
1828:
1829: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'From sequence, next po_header_id='||l_valid_headers.po_header_id(l_count)); END IF;
1830:
1831: l_progress := '060';

Line 2828: NULL, --lines.dual_uom_deviation_high, TODO: Not present in 11.5.9. For 11.5.10, default NULL

2824: NULL, --lines.job_business_group_id, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2825: NULL, --lines.job_business_group_name, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2826: NULL, --lines.tracking_quantity_ind, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2827: NULL, --lines.secondary_default_ind, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2828: NULL, --lines.dual_uom_deviation_high, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2829: NULL, --lines.dual_uom_deviation_low, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2830: lines.processing_id,
2831: NULL, --lines.line_loc_populated_flag, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2832: lines.catalog_name,

Line 2829: NULL, --lines.dual_uom_deviation_low, TODO: Not present in 11.5.9. For 11.5.10, default NULL

2825: NULL, --lines.job_business_group_name, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2826: NULL, --lines.tracking_quantity_ind, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2827: NULL, --lines.secondary_default_ind, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2828: NULL, --lines.dual_uom_deviation_high, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2829: NULL, --lines.dual_uom_deviation_low, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2830: lines.processing_id,
2831: NULL, --lines.line_loc_populated_flag, TODO: Not present in 11.5.9. For 11.5.10, default NULL
2832: lines.catalog_name,
2833: lines.supplier_part_auxid,

Line 3060: l_doc_lines_table.dual_uom_deviation_high,

3056: l_doc_lines_table.job_business_group_id,
3057: l_doc_lines_table.job_business_group_name,
3058: l_doc_lines_table.tracking_quantity_ind,
3059: l_doc_lines_table.secondary_default_ind,
3060: l_doc_lines_table.dual_uom_deviation_high,
3061: l_doc_lines_table.dual_uom_deviation_low,
3062: l_doc_lines_table.processing_id,
3063: l_doc_lines_table.line_loc_populated_flag,
3064: l_doc_lines_table.catalog_name,

Line 3061: l_doc_lines_table.dual_uom_deviation_low,

3057: l_doc_lines_table.job_business_group_name,
3058: l_doc_lines_table.tracking_quantity_ind,
3059: l_doc_lines_table.secondary_default_ind,
3060: l_doc_lines_table.dual_uom_deviation_high,
3061: l_doc_lines_table.dual_uom_deviation_low,
3062: l_doc_lines_table.processing_id,
3063: l_doc_lines_table.line_loc_populated_flag,
3064: l_doc_lines_table.catalog_name,
3065: l_doc_lines_table.supplier_part_auxid,

Line 3276: FROM DUAL;

3272:
3273: -- pick a new key from temp table which will be used in all validate logic
3274: SELECT PO_SESSION_GT_S.nextval
3275: INTO l_key
3276: FROM DUAL;
3277:
3278: l_progress := '020';
3279: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_doc_lines_rec.interface_line_id.COUNT);
3280:

Line 3399: FROM dual;

3395: l_progress := '040';
3396: -- Get the next po_line_id from the sequence
3397: SELECT PO_LINES_S.nextval
3398: INTO l_valid_lines.po_line_id(l_count)
3399: FROM dual;
3400:
3401: l_progress := '050';
3402: -- Assign Line Numbers.
3403: -- For each PO Header, assign a value in l_max_line_num array.

Line 3621: l_valid_lines.dual_uom_deviation_high(l_count) := p_doc_lines_rec.dual_uom_deviation_high(i);

3617: l_valid_lines.job_business_group_id(l_count) := p_doc_lines_rec.job_business_group_id(i);
3618: l_valid_lines.job_business_group_name(l_count) := p_doc_lines_rec.job_business_group_name(i);
3619: l_valid_lines.tracking_quantity_ind(l_count) := p_doc_lines_rec.tracking_quantity_ind(i);
3620: l_valid_lines.secondary_default_ind(l_count) := p_doc_lines_rec.secondary_default_ind(i);
3621: l_valid_lines.dual_uom_deviation_high(l_count) := p_doc_lines_rec.dual_uom_deviation_high(i);
3622: l_valid_lines.dual_uom_deviation_low(l_count) := p_doc_lines_rec.dual_uom_deviation_low(i);
3623: l_valid_lines.processing_id(l_count) := p_doc_lines_rec.processing_id(i);
3624: l_valid_lines.line_loc_populated_flag(l_count) := p_doc_lines_rec.line_loc_populated_flag(i);
3625: l_valid_lines.catalog_name(l_count) := p_doc_lines_rec.catalog_name(i);

Line 3622: l_valid_lines.dual_uom_deviation_low(l_count) := p_doc_lines_rec.dual_uom_deviation_low(i);

3618: l_valid_lines.job_business_group_name(l_count) := p_doc_lines_rec.job_business_group_name(i);
3619: l_valid_lines.tracking_quantity_ind(l_count) := p_doc_lines_rec.tracking_quantity_ind(i);
3620: l_valid_lines.secondary_default_ind(l_count) := p_doc_lines_rec.secondary_default_ind(i);
3621: l_valid_lines.dual_uom_deviation_high(l_count) := p_doc_lines_rec.dual_uom_deviation_high(i);
3622: l_valid_lines.dual_uom_deviation_low(l_count) := p_doc_lines_rec.dual_uom_deviation_low(i);
3623: l_valid_lines.processing_id(l_count) := p_doc_lines_rec.processing_id(i);
3624: l_valid_lines.line_loc_populated_flag(l_count) := p_doc_lines_rec.line_loc_populated_flag(i);
3625: l_valid_lines.catalog_name(l_count) := p_doc_lines_rec.catalog_name(i);
3626: l_valid_lines.supplier_part_auxid(l_count) := p_doc_lines_rec.supplier_part_auxid(i);