DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on PO_LINES_TRX_V

Line 2427: FROM PO_LINES_TRX_V

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
2429: AND po_header_id = x_po_header_id)
2430: AND shipment_num = x_po_shipments;
2431: /*

Line 3855: FROM PO_LINES_TRX_V

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
3857: AND po_header_id = :2)
3858: AND shipment_num like :3';
3859:

Line 5418: PO_LINES_TRX_V pl

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
5422: AND pl.line_num = p_line_num