eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_UI_RCV_LOVS dependencies on RCV_SUPPLY

Line 59: FROM rcv_supply ms

55: , poh.vendor_site_id
56: , 'Vendor'
57: , poh.note_to_receiver
58: , to_char(poh.org_id) --
59: FROM rcv_supply ms
60: , rcv_transactions rt
61: , po_headers_all poh
62: , po_lines_all pol
63: , po_line_types plt

Line 109: FROM rcv_Supply ms ,

105: 'Vendor' ,
106: poh.Note_To_Receiver ,
107: to_char(poh.org_id) --
108:
109: FROM rcv_Supply ms ,
110: rcv_Transactions rt,
111: po_Headers_trx_v poh , -- CLM, bug 9403291
112: mtl_Parameters mp
113: WHERE poh.po_Header_Id = ms.po_Header_Id

Line 270: FROM RCV_SUPPLY RSUP,

266: poh.vendor_site_id ,
267: 'Vendor' ,
268: poh.note_to_receiver ,
269: to_char(poh.org_id)
270: FROM RCV_SUPPLY RSUP,
271: RCV_TRANSACTIONS RT,
272: PO_LOOKUP_CODES PLC,
273: PO_LINES_trx_v pol, -- CLM project, bug 9403291
274: PO_LINE_LOCATIONS_trx_v PLL, -- CLM project, bug 9403291

Line 379: from rcv_supply rsup

375: OPEN x_po_release_num_lov FOR
376: select distinct pr.release_num
377: , pr.po_release_id
378: , pr.release_date
379: from rcv_supply rsup
380: , po_releases_all pr
381: where rsup.po_header_id = p_po_header_id
382: --AND pr.org_id = p_organization_id
383: and nvl(pr.cancel_flag, 'N') = 'N'

Line 487: FROM rcv_supply rsup

483: , inv_ui_item_lovs.get_conversion_rate(mum.uom_code,
484: p_organization_id,
485: pl.Item_Id)
486: uom_code
487: FROM rcv_supply rsup
488: -- bug 2805640
489: , mtl_units_of_measure mum
490: , po_lines_trx_v pl -- CLM project, bug 9403291
491: , mtl_system_items_vl msi

Line 614: rcv_supply ms,

610: rsh.freight_carrier_code
611: FROM
612: rcv_shipment_headers rsh,
613: rcv_shipment_lines rsl,
614: rcv_supply ms,
615: rcv_transactions rt,
616: org_organization_definitions ood
617: WHERE rsh.shipment_header_id = ms.shipment_header_id
618: AND ms.to_organization_id = p_organization_id

Line 717: FROM RCV_SUPPLY RSUP,

713: rsh.packing_slip,
714: rsh.bill_of_lading,
715: rsh.waybill_airbill_num,
716: rsh.freight_carrier_code
717: FROM RCV_SUPPLY RSUP,
718: RCV_SHIPMENT_LINES RSL,
719: RCV_TRANSACTIONS RT,
720: RCV_SHIPMENT_HEADERS RSH,
721: PO_LOOKUP_CODES PLC,

Line 789: rcv_supply ms,

785: NULL,
786: to_char(prh.org_id) --
787: FROM
788: po_req_headers_trx_v prh, -- CLM project, bug 9403291
789: rcv_supply ms,
790: po_req_lines_trx_v prl, -- CLM project, bug 9403291
791: rcv_transactions rt
792: WHERE
793: prh.requisition_header_id = ms.req_header_id

Line 955: FROM rcv_supply ms

951: , rt.po_header_id
952: , rt.oe_order_header_id
953: , rt.po_release_id --bug6594996 add PO release header ID associated with the receip
954: , ms.from_organization_id -- bug #6917248
955: FROM rcv_supply ms
956: , rcv_transactions rt
957: , rcv_shipment_headers rsh
958: , rcv_shipment_lines rsl
959: , mtl_parameters mp

Line 1112: FROM RCV_SUPPLY RSUP,

1108: null ,
1109: null
1110: , null -- bug # 6917248
1111: , rsup.from_organization_id -- bug # 6917248
1112: FROM RCV_SUPPLY RSUP,
1113: RCV_TRANSACTIONS RT,
1114: RCV_SHIPMENT_HEADERS RSH,
1115: RCV_SHIPMENT_LINES RSL,
1116: PO_LOOKUP_CODES PLC,

Line 1185: rcv_supply ms,

1181: oec.customer_id,
1182: oec.name customer_name,
1183: oec.customer_number
1184: FROM rcv_transactions rt,
1185: rcv_supply ms,
1186: oe_order_headers_all oeh,
1187: oe_order_lines_all oel,
1188: -- oe_line_types_v oet,
1189: OE_TRANSACTION_TYPES_TL OTT_TL,

Line 3079: FROM rcv_supply rsup

3075: , inv_ui_item_lovs.get_conversion_rate(mum.uom_code,
3076: p_organization_id,
3077: pl.Item_Id)
3078: uom_code
3079: FROM rcv_supply rsup
3080: , mtl_units_of_measure mum
3081: , po_lines_trx_v pl -- CLM project, bug 9403291
3082: , mtl_system_items_vl msi
3083: WHERE rsup.po_line_id = pl.po_line_id

Line 3279: from rcv_supply rsup

3275: OPEN x_po_release_num_lov FOR
3276: select distinct pr.release_num
3277: , pr.po_release_id
3278: , pr.release_date
3279: from rcv_supply rsup
3280: , po_releases_all pr
3281: where rsup.po_header_id = p_po_header_id
3282: --AND pr.org_id = p_organization_id
3283: and nvl(pr.cancel_flag, 'N') = 'N'

Line 8615: from rcv_supply

8611: AND concatenated_segments like p_concatenated_segments||l_append
8612: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8613: AND msik.inventory_item_id IN (
8614: SELECT item_id
8615: from rcv_supply
8616: WHERE shipment_header_id = p_shipmentHeaderReceipt
8617: )
8618: UNION
8619:

Line 8680: from rcv_supply

8676: OR mcr.org_independent_flag = 'Y' )
8677: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8678: AND msik.inventory_item_id IN (
8679: SELECT item_id
8680: from rcv_supply
8681: WHERE shipment_header_id = p_shipmentHeaderReceipt
8682: );
8683:
8684: ELSIF (p_poHeaderID IS NOT NULL ) THEN

Line 8741: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_release_id = p_poReleaseID)

8737: WHERE
8738: organization_id = p_Organization_Id
8739: AND concatenated_segments like p_concatenated_segments||l_append
8740: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8741: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_release_id = p_poReleaseID)
8742: UNION
8743: select
8744: concatenated_segments,
8745: msik.inventory_item_id,

Line 8801: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_release_id = p_poReleaseID);

8797: AND mcr.cross_reference like g_crossref
8798: AND (mcr.organization_id = msik.organization_id
8799: OR mcr.org_independent_flag = 'Y' )
8800: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8801: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_release_id = p_poReleaseID);
8802:
8803: ELSIF (p_poLineID IS NOT null ) THEN
8804: open x_items for
8805: SELECT

Line 8858: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_line_id = p_poLineID )

8854: WHERE
8855: organization_id = p_Organization_Id
8856: AND concatenated_segments like p_concatenated_segments||l_append
8857: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8858: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_line_id = p_poLineID )
8859: UNION
8860: select
8861: concatenated_segments,
8862: msik.inventory_item_id,

Line 8918: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_line_id = p_poLineID );

8914: AND mcr.cross_reference like g_crossref
8915: AND (mcr.organization_id = msik.organization_id
8916: OR mcr.org_independent_flag = 'Y' )
8917: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8918: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_line_id = p_poLineID );
8919:
8920: ELSE
8921: open x_items for
8922: SELECT

Line 8975: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID )

8971: WHERE
8972: organization_id = p_Organization_Id
8973: AND concatenated_segments like p_concatenated_segments||l_append
8974: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8975: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID )
8976: UNION
8977: select
8978: concatenated_segments,
8979: msik.inventory_item_id,

Line 9035: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID );

9031: AND mcr.cross_reference like g_crossref
9032: AND (mcr.organization_id = msik.organization_id
9033: OR mcr.org_independent_flag = 'Y' )
9034: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
9035: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID );
9036: end if;
9037:
9038: ELSIF (p_shipmentHeaderID IS NOT null ) THEN
9039: open x_items for

Line 9093: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE SHIPMENT_HEADER_ID = p_shipmentHeaderID )

9089: WHERE
9090: organization_id = p_Organization_Id
9091: AND concatenated_segments like p_concatenated_segments||l_append
9092: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
9093: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE SHIPMENT_HEADER_ID = p_shipmentHeaderID )
9094: UNION
9095: select
9096: concatenated_segments,
9097: msik.inventory_item_id,

Line 9153: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE SHIPMENT_HEADER_ID = p_shipmentHeaderID );

9149: AND mcr.cross_reference like g_crossref
9150: AND (mcr.organization_id = msik.organization_id
9151: OR mcr.org_independent_flag = 'Y' )
9152: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
9153: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE SHIPMENT_HEADER_ID = p_shipmentHeaderID );
9154:
9155: ELSIF (p_reqHeaderID IS NOT NULL ) THEN
9156: open x_items for
9157: SELECT

Line 9213: AND EXISTS(SELECT 1 FROM rcv_supply rs WHERE rs.req_line_id=prl.requisition_line_id and rs.supply_type_code = 'RECEIVING'))

9209: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
9210: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines prl WHERE prl.requisition_header_id = p_reqHeaderID
9211: -- Bug 4346684
9212: -- Add condition to filter the item that dosen't exists in shipments.
9213: AND EXISTS(SELECT 1 FROM rcv_supply rs WHERE rs.req_line_id=prl.requisition_line_id and rs.supply_type_code = 'RECEIVING'))
9214:
9215: UNION
9216: select
9217: concatenated_segments,

Line 9277: AND EXISTS(SELECT 1 FROM rcv_supply rs WHERE rs.req_line_id=prl.requisition_line_id and rs.supply_type_code = 'RECEIVING'));

9273: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
9274: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines prl WHERE prl.requisition_header_id = p_reqHeaderID
9275: -- Bug 4346684
9276: -- Add condition to filter the item that dosen't exists in shipments.
9277: AND EXISTS(SELECT 1 FROM rcv_supply rs WHERE rs.req_line_id=prl.requisition_line_id and rs.supply_type_code = 'RECEIVING'));
9278:
9279:
9280: ELSIF (p_oeOrderHeaderID IS NOT NULL ) THEN
9281: open x_items for

Line 9335: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE OE_ORDER_HEADER_ID = p_oeOrderHeaderID )

9331: WHERE
9332: organization_id = p_Organization_Id
9333: AND concatenated_segments like p_concatenated_segments||l_append
9334: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
9335: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE OE_ORDER_HEADER_ID = p_oeOrderHeaderID )
9336: UNION
9337: select
9338: concatenated_segments,
9339: msik.inventory_item_id,

Line 9395: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE OE_ORDER_HEADER_ID = p_oeOrderHeaderID );

9391: AND mcr.cross_reference like g_crossref
9392: AND (mcr.organization_id = msik.organization_id
9393: OR mcr.org_independent_flag = 'Y' )
9394: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
9395: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE OE_ORDER_HEADER_ID = p_oeOrderHeaderID );
9396:
9397: END IF;
9398:
9399: END GET_INV_ITEM_LOV_RECEIVING;