APPS.QA_PLAN_ELEMENT_API dependencies on PO_LINES

Line 2374: FROM po_lines_val_v

2370: RETURN BOOLEAN IS
2371:
2372: CURSOR c IS
2373: SELECT 1
2374: FROM po_lines_val_v
2375: WHERE po_header_id = x_po_header_id
2376: AND line_num = x_po_line_number;
2377:
2378: result BOOLEAN;

Line 2403: FROM po_lines

2399: SELECT 1
2400: FROM po_line_locations
2401: WHERE po_line_id =
2402: ( SELECT po_line_id
2403: FROM po_lines
2404: WHERE line_num = x_po_line_num
2405: AND po_header_id = x_po_header_id)
2406: AND shipment_num = x_po_shipments;
2407: /*

Line 2412: FROM po_lines_val_v

2408: SELECT 1
2409: FROM po_shipments_all_v
2410: WHERE po_line_id =
2411: (SELECT po_line_id
2412: FROM po_lines_val_v
2413: WHERE line_num = x_po_line_num
2414: AND po_header_id = x_po_header_id)
2415: AND shipment_num = x_po_shipments;
2416: */

Line 3706: FROM po_lines_val_v

3702: -- After Single Scan LOV
3703: wild := value;
3704:
3705: sql_string := 'SELECT line_num, concatenated_segments
3706: FROM po_lines_val_v
3707: WHERE po_header_id = :1
3708: AND line_num like :2
3709: ORDER BY line_num';
3710:

Line 3745: FROM po_lines_val_v

3741: sql_string := 'SELECT shipment_num, shipment_type
3742: FROM po_shipments_all_v
3743: WHERE po_line_id =
3744: (SELECT po_line_id
3745: FROM po_lines_val_v
3746: WHERE line_num = :1
3747: AND po_header_id = :2)
3748: AND shipment_num like :3';
3749: */

Line 3755: FROM po_lines

3751: sql_string := 'SELECT shipment_num, shipment_type
3752: FROM po_line_locations
3753: WHERE po_line_id =
3754: (SELECT po_line_id
3755: FROM po_lines
3756: WHERE line_num = :1
3757: AND po_header_id = :2)
3758: AND shipment_num like :3';
3759:

Line 5214: po_lines_all pl

5210: CURSOR C1 IS
5211: SELECT (pll.quantity_received - (pll.quantity_accepted + pll.quantity_rejected)) quantity_received
5212: FROM po_headers_all ph,
5213: po_line_locations_all pll,
5214: po_lines_all pl
5215: WHERE pll.po_header_id = ph.po_header_id
5216: AND pll.po_line_id = pl.po_line_id
5217: AND pll.shipment_num = p_ship_num
5218: AND pl.line_num = p_line_num