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_SHIPMENT_LINES

Line 202: , rcv_shipment_lines rsl

198: , 'Vendor'
199: , poh.note_to_receiver
200: , to_char(poh.org_id) --
201: FROM po_headers_all poh
202: , rcv_shipment_lines rsl
203: WHERE exists (SELECT 'Valid PO Shipments'
204: FROM po_line_locations poll
205: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
206: , mtl_parameters mp,

Line 585: rcv_shipment_lines rsl,

581: rsh.waybill_airbill_num,
582: rsh.freight_carrier_code
583: FROM
584: rcv_shipment_headers rsh,
585: rcv_shipment_lines rsl,
586: rcv_supply ms,
587: rcv_transactions rt,
588: org_organization_definitions ood
589: WHERE rsh.shipment_header_id = ms.shipment_header_id

Line 628: rcv_shipment_lines sl

624: sh.bill_of_lading,
625: sh.waybill_airbill_num,
626: sh.freight_carrier_code
627: FROM rcv_shipment_headers sh,
628: rcv_shipment_lines sl
629: WHERE sh.shipment_num IS NOT NULL
630: AND sh.shipment_header_id = sl.shipment_header_id
631: AND sl.to_organization_id = p_organization_id
632: AND sh.receipt_source_code IN ('INTERNAL ORDER','INVENTORY')

Line 658: rcv_shipment_lines sl

654: sh.bill_of_lading,
655: sh.waybill_airbill_num,
656: sh.freight_carrier_code
657: FROM rcv_shipment_headers sh,
658: rcv_shipment_lines sl
659: WHERE sh.shipment_num IS NOT NULL
660: AND sh.shipment_header_id = sl.shipment_header_id
661: AND sl.to_organization_id = p_organization_id
662: AND sl.po_header_id = Nvl(To_number(p_po_header_id), sl.po_header_id)

Line 690: RCV_SHIPMENT_LINES RSL,

686: rsh.bill_of_lading,
687: rsh.waybill_airbill_num,
688: rsh.freight_carrier_code
689: FROM RCV_SUPPLY RSUP,
690: RCV_SHIPMENT_LINES RSL,
691: RCV_TRANSACTIONS RT,
692: RCV_SHIPMENT_HEADERS RSH,
693: PO_LOOKUP_CODES PLC,
694: PO_LINE_LOCATIONS_ALL PLL,

Line 810: FROM rcv_shipment_lines rsl

806: AND prh.authorization_status || '' = 'APPROVED'
807: AND prh.segment1 LIKE (p_requisition_num)
808: AND exists
809: (SELECT 1
810: FROM rcv_shipment_lines rsl
811: WHERE rsl.requisition_line_id = prl.requisition_line_id
812: AND rsl.routing_header_id > 0
813: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED')
814: ORDER BY prh.segment1;

Line 838: FROM rcv_shipment_lines rsl,

834: AND prh.authorization_status || '' = 'APPROVED'
835: AND prh.segment1 LIKE (p_requisition_num)
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

Line 879: rcv_shipment_lines sl

875: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
876: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
877: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization')
878: FROM rcv_shipment_headers sh,
879: rcv_shipment_lines sl
880: WHERE sh.packing_slip IS NOT NULL
881: AND sh.shipment_header_id = sl.shipment_header_id
882: AND sl.to_organization_id = p_organization_id
883: AND sl.po_header_id = To_number(p_po_header_id)

Line 899: rcv_shipment_lines sl

895: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
896: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
897: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization')
898: FROM rcv_shipment_headers sh,
899: rcv_shipment_lines sl
900: WHERE sh.packing_slip IS NOT NULL
901: AND sh.shipment_header_id = sl.shipment_header_id
902: AND sl.to_organization_id = p_organization_id
903: AND sl.po_header_id = Nvl(To_number(p_po_header_id), sl.po_header_id)

Line 928: , rcv_shipment_lines rsl

924: , rt.oe_order_header_id
925: FROM rcv_supply ms
926: , rcv_transactions rt
927: , rcv_shipment_headers rsh
928: , rcv_shipment_lines rsl
929: , mtl_parameters mp
930: WHERE rsh.shipment_header_id = ms.shipment_header_id
931: AND rsh.shipment_header_id = rt.shipment_header_id
932: AND ms.to_organization_id = p_organization_id

Line 1083: RCV_SHIPMENT_LINES RSL,

1079: null
1080: FROM RCV_SUPPLY RSUP,
1081: RCV_TRANSACTIONS RT,
1082: RCV_SHIPMENT_HEADERS RSH,
1083: RCV_SHIPMENT_LINES RSL,
1084: PO_LOOKUP_CODES PLC,
1085: PO_LINE_LOCATIONS_ALL PLL,
1086: mtl_parameters mp --BUG 5166887
1087: WHERE RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'

Line 2052: rcv_shipment_lines sl

2048: lookup_code FIELD13,
2049: NULL FIELD14 --
2050: FROM fnd_lookup_values_vl flv,
2051: rcv_shipment_headers sh,
2052: rcv_shipment_lines sl
2053: WHERE flv.lookup_code = 'INTSHIP'
2054: AND flv.lookup_type = 'DOC_TYPE'
2055: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2056: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2099: rcv_shipment_lines sl

2095: lookup_code FIELD13,
2096: NULL FIELD14 --
2097: FROM fnd_lookup_values_vl flv,
2098: rcv_shipment_headers sh,
2099: rcv_shipment_lines sl
2100: WHERE flv.lookup_code = 'ASN'
2101: AND flv.lookup_type = 'DOC_TYPE'
2102: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2103: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2141: rcv_shipment_lines sl

2137: lookup_code FIELD13,
2138: NULL FIELD14 --
2139: FROM fnd_lookup_values_vl flv,
2140: rcv_shipment_headers sh,
2141: rcv_shipment_lines sl
2142: WHERE flv.lookup_code = 'ASN'
2143: AND flv.lookup_type = 'DOC_TYPE'
2144: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2145: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2184: rcv_shipment_lines sl

2180: lookup_code FIELD13 ,
2181: NULL FIELD14 --
2182: FROM fnd_lookup_values_vl flv,
2183: rcv_shipment_headers sh,
2184: rcv_shipment_lines sl
2185: WHERE flv.lookup_code = 'ASN'
2186: AND flv.lookup_type = 'DOC_TYPE'
2187: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2188: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2227: rcv_shipment_lines sl

2223: lookup_code FIELD13,
2224: NULL FIELD14 --
2225: FROM fnd_lookup_values_vl flv,
2226: rcv_shipment_headers sh,
2227: rcv_shipment_lines sl
2228: WHERE flv.lookup_code = 'LCM'
2229: AND flv.lookup_type = 'DOC_TYPE'
2230: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2231: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2269: rcv_shipment_lines sl

2265: lookup_code FIELD13,
2266: NULL FIELD14 --
2267: FROM fnd_lookup_values_vl flv,
2268: rcv_shipment_headers sh,
2269: rcv_shipment_lines sl
2270: WHERE flv.lookup_code = 'LCM'
2271: AND flv.lookup_type = 'DOC_TYPE'
2272: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2273: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2312: rcv_shipment_lines sl

2308: lookup_code FIELD13 ,
2309: NULL FIELD14 --
2310: FROM fnd_lookup_values_vl flv,
2311: rcv_shipment_headers sh,
2312: rcv_shipment_lines sl
2313: WHERE flv.lookup_code = 'LCM'
2314: AND flv.lookup_type = 'DOC_TYPE'
2315: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2316: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2368: FROM rcv_shipment_lines rsl

2364: AND EXISTS
2365: (
2366: SELECT
2367: 1
2368: FROM rcv_shipment_lines rsl
2369: WHERE rsl.requisition_line_id = prl.requisition_line_id
2370: AND rsl.routing_header_id > 0 --Bug 3349131
2371: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
2372: AND rsl.item_id LIKE Nvl(p_inventory_item_id,rsl.item_id)

Line 2678: rcv_shipment_lines sl

2674: lookup_code FIELD13,
2675: NULL FIELD14 --
2676: FROM fnd_lookup_values_vl flv,
2677: rcv_shipment_headers sh,
2678: rcv_shipment_lines sl
2679: WHERE flv.lookup_code = 'INTSHIP'
2680: AND flv.lookup_type = 'DOC_TYPE'
2681: AND nvl(flv.start_date_active, SYSDATE )<= SYSDATE
2682: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2722: rcv_shipment_lines sl

2718: lookup_code FIELD13,
2719: NULL FIELD14 --
2720: FROM fnd_lookup_values_vl flv,
2721: rcv_shipment_headers sh,
2722: rcv_shipment_lines sl
2723: WHERE flv.lookup_code = 'ASN'
2724: AND flv.lookup_type = 'DOC_TYPE'
2725: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2726: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2775: rcv_shipment_lines sl

2771: lookup_code FIELD13,
2772: NULL FIELD14 --
2773: FROM fnd_lookup_values_vl flv,
2774: rcv_shipment_headers sh,
2775: rcv_shipment_lines sl
2776: WHERE flv.lookup_code = 'LCM'
2777: AND flv.lookup_type = 'DOC_TYPE'
2778: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2779: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2842: FROM rcv_shipment_lines rsl

2838: AND EXISTS
2839: (
2840: SELECT
2841: 1
2842: FROM rcv_shipment_lines rsl
2843: WHERE rsl.requisition_line_id = prl.requisition_line_id
2844: AND rsl.routing_header_id > 0 --Bug 3349131
2845: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
2846: AND rsl.item_id LIKE Nvl(p_inventory_item_id,rsl.item_id)

Line 5966: rcv_shipment_lines rsl

5962: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5963: NVL(DUAL_UOM_DEVIATION_LOW,0),
5964: stock_enabled_flag
5965: from mtl_system_items_vl msn, /* Bug 5581528 */
5966: rcv_shipment_lines rsl
5967: WHERE msn.organization_id = p_Organization_Id
5968: and msn.concatenated_segments like p_concatenated_segments
5969: and (msn.purchasing_enabled_flag = 'Y' OR msn.stock_enabled_flag = 'Y')
5970: and rsl.SHIPMENT_HEADER_ID = p_shipmentHeaderID

Line 6036: , rcv_shipment_lines rsl

6032: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6033: msi.stock_enabled_flag
6034: from po_lines_all pol
6035: ,mtl_system_items_vl msi /* Bug 5581528 */
6036: , rcv_shipment_lines rsl
6037: where organization_id = p_Organization_Id
6038: and pol.vendor_product_num like p_concatenated_segments
6039: and pol.item_id = msi.inventory_item_id
6040: and pol.vendor_product_num IS NOT NULL

Line 6130: , rcv_shipment_lines rsl

6126: 0,
6127: 'N'
6128: from po_lines_all pol
6129: , mtl_units_of_measure mum
6130: , rcv_shipment_lines rsl
6131: -- Bug 2619063, 2614016
6132: -- Modified to select the base uom for the uom class defined on po.
6133: where mum.uom_class = (SELECT mum2.uom_class
6134: FROM mtl_units_of_measure mum2

Line 6216: rcv_shipment_lines rsl,

6212: NVL(MSN.DUAL_UOM_DEVIATION_HIGH,0),
6213: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),
6214: msn.stock_enabled_flag
6215: from mtl_system_items_vl msn, /* Bug 5581528 */
6216: rcv_shipment_lines rsl,
6217: mtl_cross_references mcr
6218: WHERE msn.organization_id = p_Organization_Id
6219: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
6220: AND mcr.cross_reference LIKE g_crossref

Line 6448: rcv_shipment_lines rsl , po_req_distributions_all prd

6444: WHERE organization_id = p_Organization_Id
6445: and concatenated_segments like p_concatenated_segments
6446: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
6447: and exists (SELECT 1 FROM po_requisition_lines_all prl,
6448: rcv_shipment_lines rsl , po_req_distributions_all prd
6449: WHERE prl.requisition_header_id = p_reqHeaderID
6450: and rsl.item_id = inventory_item_id
6451: and ( (l_from_lpn_id is null)
6452: or (l_from_lpn_id is not null and exists

Line 6527: rcv_shipment_lines rsl , po_req_distributions_all prd

6523: ) )
6524: and mcr.inventory_item_id = msi.inventory_item_id
6525: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
6526: and exists (SELECT 1 FROM po_requisition_lines_all prl,
6527: rcv_shipment_lines rsl , po_req_distributions_all prd
6528: WHERE prl.requisition_header_id = p_reqHeaderID
6529: and rsl.item_id = msi.inventory_item_id
6530: and ( (l_from_lpn_id is null)
6531: or (l_from_lpn_id is not null and exists

Line 6602: rcv_Shipment_Lines rsl ,

6598: /* Bug 5581528 */
6599: (
6600: SELECT DISTINCT rsl.Item_Id
6601: FROM po_Requisition_Lines_All prl,
6602: rcv_Shipment_Lines rsl ,
6603: po_req_Distributions_All prd
6604: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
6605: AND l_From_lpn_Id IS NOT NULL
6606: AND EXISTS

Line 6682: rcv_Shipment_Lines rsl ,

6678: /* Bug 5581528 */
6679: (
6680: SELECT DISTINCT rsl.Item_Id
6681: FROM po_Requisition_Lines_All prl,
6682: rcv_Shipment_Lines rsl ,
6683: po_req_Distributions_All prd
6684: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
6685: AND l_From_lpn_Id IS NULL
6686: AND prl.Requisition_Line_Id = rsl.Requisition_Line_Id

Line 6767: rcv_shipment_lines rsl ,

6763: OR stock_enabled_flag = 'Y')
6764: AND EXISTS
6765: (SELECT 1
6766: FROM po_requisition_lines_all prl,
6767: rcv_shipment_lines rsl ,
6768: po_req_distributions_all prd
6769: WHERE prl.requisition_header_id = p_reqHeaderID
6770: AND rsl.item_id = msi.inventory_item_id
6771: AND ( (l_from_lpn_id IS NULL)