DBA Data[Home] [Help]

APPS.QA_SS_LOV_API dependencies on PO_LINES_VAL_TRX_V

Line 581: FROM po_lines_val_trx_v

577: l_po_line_id := NULL;
578: ELSE
579: SELECT po_line_id
580: INTO l_po_line_id
581: FROM po_lines_val_trx_v
582: WHERE line_num = p_po_line
583: AND po_header_id = l_po_number_id;
584: END IF;
585:

Line 1523: FROM PO_LINES_VAL_TRX_V

1519:
1520: -- Bug 3215866 ksoh Wed Oct 29 16:21:11 PST 2003
1521: -- fixed sql to make it return value instead of id.
1522: x_lov_sql := 'SELECT to_char(line_num), concatenated_segments
1523: FROM PO_LINES_VAL_TRX_V
1524: WHERE po_header_id = :1
1525: ORDER BY line_num';
1526:
1527: END get_po_line_number_lov;

Line 1652: from po_lines_val_trx_v

1648:
1649: x_lov_sql := 'select to_char(shipment_num) shipment_number,shipment_type
1650: from po_shipments_all_v
1651: where po_line_id = (select po_line_id
1652: from po_lines_val_trx_v
1653: where line_num = :1
1654: and po_header_id = :2)
1655: and po_release_id = :3';
1656: