APPS.INV_UI_RCV_LOVS dependencies on RCV_TRANSACTIONS_V

Line 237: RCV_TRANSACTIONS_V

233: ELSIF p_mobile_form = 'INSPECT' THEN
234: OPEN x_po_num_lov FOR
235: /*Bug: 4951739
236: Modified query: Referencing base table instead of
237: RCV_TRANSACTIONS_V
238: */
239: SELECT DISTINCT poh.segment1 ,
240: poh.po_header_id ,
241: poh.type_lookup_code ,

Line 676: RCV_TRANSACTIONS_V

672: ELSIF p_mobile_form = 'INSPECT' THEN
673: OPEN x_shipment_num_lov FOR
674: /*Bug: 4951739
675: Modified query: Referencing base table instead of
676: RCV_TRANSACTIONS_V
677: */
678: SELECT DISTINCT rsh.shipment_num,
679: rsh.shipment_header_id,
680: rsh.shipped_date,

Line 840: rcv_transactions_v rtv

836: AND exists
837: (SELECT 1
838: FROM rcv_shipment_lines rsl,
839: rcv_shipment_headers rsh,
840: rcv_transactions_v rtv
841: WHERE rsl.requisition_line_id = prl.requisition_line_id
842: AND rsh.shipment_header_id = rsl.shipment_header_id
843: AND rtv.shipment_header_id = rsh.shipment_header_id
844: AND rtv.shipment_line_id = rsl.shipment_line_id

Line 1072: RCV_TRANSACTIONS_V

1068: begin
1069: OPEN x_getRcptNumLOV FOR
1070: /*Bug: 4951739
1071: Modified query: Referencing base table instead of
1072: RCV_TRANSACTIONS_V
1073: */
1074: SELECT DISTINCT rsh.receipt_num ,
1075: null ,
1076: rsup.shipment_header_id ,

Line 1257: FROM rcv_transactions_v rtv,

1253: -- oet.ORDER_CATEGORY_CODE ,
1254: oec.customer_id,
1255: oec.name customer_name,
1256: oec.customer_number
1257: FROM rcv_transactions_v rtv,
1258: oe_order_headers_all oeh,
1259: OE_TRANSACTION_TYPES_TL OTT_TL,
1260: OE_TRANSACTION_TYPES_ALL OTT_ALL,
1261: oe_order_lines_all oel,