APPS.QA_PLAN_ELEMENT_API dependencies on PO_LINES_VAL_TRX_V

Line 2393: FROM PO_LINES_VAL_TRX_V

2389: RETURN BOOLEAN IS
2390:
2391: CURSOR c IS
2392: SELECT 1
2393: FROM PO_LINES_VAL_TRX_V
2394: WHERE po_header_id = x_po_header_id
2395: AND line_num = x_po_line_number;
2396:
2397: result BOOLEAN;

Line 3039: FROM po_lines_val_trx_v

3035: l_po_line_id := NULL;
3036: ELSE
3037: SELECT po_line_id
3038: INTO l_po_line_id
3039: FROM po_lines_val_trx_v
3040: WHERE line_num = po_line_num
3041: AND po_header_id = p_po_header_id;
3042: END IF;
3043:

Line 3801: FROM PO_LINES_VAL_TRX_V

3797: --
3798: -- bug 9652444 CLM changes
3799: --
3800: sql_string := 'SELECT line_num, concatenated_segments
3801: FROM PO_LINES_VAL_TRX_V
3802: WHERE po_header_id = :1
3803: AND line_num like :2
3804: ORDER BY line_num';
3805:

Line 3887: FROM po_lines_val_trx_v

3883:
3884: sql_string := 'SELECT shipment_num, shipment_type
3885: FROM po_shipments_all_v
3886: WHERE po_line_id = (SELECT po_line_id
3887: FROM po_lines_val_trx_v
3888: WHERE line_num = :1
3889: AND po_header_id = :2)
3890: AND nvl(po_release_id,1) = nvl(:3,1)
3891: AND shipment_num LIKE :4';