APPS.PO_DOCUMENT_TOTALS_PVT dependencies on DUAL

Line 3511: SELECT PO_DOCUMENT_TOTALS_GT_S.nextval INTO l_temp_table_key from dual;

3507:
3508: d_position := 5;
3509:
3510: -- Select the unique key to identify GTT rows for this trxn
3511: SELECT PO_DOCUMENT_TOTALS_GT_S.nextval INTO l_temp_table_key from dual;
3512:
3513: IF p_data_source = g_data_source_TRANSACTION THEN
3514:
3515: d_position := 10;

Line 4088: -- the max received, billed etc against the individual Milestone pay items

4084:
4085: d_position := 40;
4086:
4087: -- SQL WHAT: For Complex Work Qty-based lines, the total is based on
4088: -- the max received, billed etc against the individual Milestone pay items
4089: -- SQL WHERE: All qty-based GTT rows for this trxn
4090: SELECT
4091: MAX(GTTSUM.qty_total_actuals),
4092: MAX(GTTSUM.qty_total_financing),