APPS.INV_UI_RCV_LOVS dependencies on RCV_TRANSACTIONS_V

Line 257: RCV_TRANSACTIONS_V

253: ELSIF p_mobile_form = 'INSPECT' THEN
254: OPEN x_po_num_lov FOR
255: /*Bug: 4951739
256: Modified query: Referencing base table instead of
257: RCV_TRANSACTIONS_V
258: */
259: SELECT DISTINCT poh.segment1 ,
260: poh.po_header_id ,
261: poh.type_lookup_code ,

Line 704: RCV_TRANSACTIONS_V

700: ELSIF p_mobile_form = 'INSPECT' THEN
701: OPEN x_shipment_num_lov FOR
702: /*Bug: 4951739
703: Modified query: Referencing base table instead of
704: RCV_TRANSACTIONS_V
705: */
706: SELECT DISTINCT rsh.shipment_num,
707: rsh.shipment_header_id,
708: rsh.shipped_date,

Line 868: rcv_transactions_v rtv

864: AND exists
865: (SELECT 1
866: FROM rcv_shipment_lines rsl,
867: rcv_shipment_headers rsh,
868: rcv_transactions_v rtv
869: WHERE rsl.requisition_line_id = prl.requisition_line_id
870: AND rsh.shipment_header_id = rsl.shipment_header_id
871: AND rtv.shipment_header_id = rsh.shipment_header_id
872: AND rtv.shipment_line_id = rsl.shipment_line_id

Line 1102: RCV_TRANSACTIONS_V

1098: begin
1099: OPEN x_getRcptNumLOV FOR
1100: /*Bug: 4951739
1101: Modified query: Referencing base table instead of
1102: RCV_TRANSACTIONS_V
1103: */
1104: SELECT DISTINCT rsh.receipt_num ,
1105: null ,
1106: rsup.shipment_header_id ,

Line 1289: FROM rcv_transactions_v rtv,

1285: -- oet.ORDER_CATEGORY_CODE ,
1286: oec.customer_id,
1287: oec.name customer_name,
1288: oec.customer_number
1289: FROM rcv_transactions_v rtv,
1290: oe_order_headers_all oeh,
1291: OE_TRANSACTION_TYPES_TL OTT_TL,
1292: OE_TRANSACTION_TYPES_ALL OTT_ALL,
1293: oe_order_lines_all oel,