APPS.QA_PLAN_ELEMENT_API dependencies on PO_LINE_LOCATIONS

Line 2424: FROM po_line_locations

2420: --
2421: -- Bug 4958763. SQL Repository Fix SQL ID: 15008958
2422: CURSOR c IS
2423: SELECT 1
2424: FROM po_line_locations
2425: WHERE po_line_id =
2426: ( SELECT po_line_id
2427: FROM PO_LINES_TRX_V
2428: WHERE line_num = x_po_line_num

Line 3047: po_line_locations_trx_v pll

3043:
3044: sql_string := 'SELECT DISTINCT to_char(pr.release_num) release_number,
3045: QLTDATE.date_to_user(pr.release_date)
3046: FROM po_releases pr,
3047: po_line_locations_trx_v pll
3048: WHERE pr.po_header_id = :1
3049: AND pr.po_header_id = pll.po_header_id
3050: AND pr.po_release_id = pll.po_release_id
3051: AND pll.po_line_id = NVL(:2, pll.po_line_id)

Line 3852: FROM PO_LINE_LOCATIONS_TRX_V

3848: --
3849: -- bug 9652549 CLM changes
3850: --
3851: sql_string := 'SELECT shipment_num, shipment_type
3852: FROM PO_LINE_LOCATIONS_TRX_V
3853: WHERE po_line_id =
3854: (SELECT po_line_id
3855: FROM PO_LINES_TRX_V
3856: WHERE line_num = :1

Line 5417: PO_LINE_LOCATIONS_TRX_V pll,

5413: --
5414: CURSOR C1 IS
5415: SELECT (pll.quantity_received - (pll.quantity_accepted + pll.quantity_rejected)) quantity_received
5416: FROM PO_HEADERS_TRX_V ph,
5417: PO_LINE_LOCATIONS_TRX_V pll,
5418: PO_LINES_TRX_V pl
5419: WHERE pll.po_header_id = ph.po_header_id
5420: AND pll.po_line_id = pl.po_line_id
5421: AND pll.shipment_num = p_ship_num