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_ITEM_ATT_LOVS dependencies on RCV_SHIPMENT_LINES

Line 27: -- and check existence in rcv_serials_supply join to rcv_shipment_lines

23: OR (current_status = 4 AND
24: Nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2
25: )
26: -- Bug# 12556104 ASN Std receipt, add serial status = 5 (Resides in intransit)
27: -- and check existence in rcv_serials_supply join to rcv_shipment_lines
28: -- and rcv_shipment_headers to ensure the serials belongs to the ASN
29: OR (CURRENT_STATUS = 5 AND EXISTS (SELECT 1
30: FROM rcv_serials_supply rss
31: ,rcv_shipment_lines rsl

Line 31: ,rcv_shipment_lines rsl

27: -- and check existence in rcv_serials_supply join to rcv_shipment_lines
28: -- and rcv_shipment_headers to ensure the serials belongs to the ASN
29: OR (CURRENT_STATUS = 5 AND EXISTS (SELECT 1
30: FROM rcv_serials_supply rss
31: ,rcv_shipment_lines rsl
32: ,rcv_shipment_headers rsh
33: WHERE rss.supply_type_code = 'SHIPMENT'
34: AND rss.serial_num = SERIAL_NUMBER
35: AND rss.shipment_line_id = rsl.shipment_line_id

Line 184: l_source_document_code rcv_shipment_lines.source_document_code%TYPE;

180: ) IS
181: l_src_org_lot_ctrl NUMBER := 1;
182: l_rcv_org_lot_ctrl NUMBER := 1;
183: l_src_org_srl_ctrl NUMBER := 1;
184: l_source_document_code rcv_shipment_lines.source_document_code%TYPE;
185: BEGIN
186:
187: BEGIN
188: --Get the lot control in source and receiving orgs and the

Line 200: , rcv_shipment_lines rsl

196: , l_rcv_org_lot_ctrl
197: , l_source_document_code
198: FROM mtl_system_items msi1
199: , mtl_system_items msi2
200: , rcv_shipment_lines rsl
201: WHERE rsl.shipment_header_id = p_shipment_header_id
202: AND rsl.to_organization_id = p_organization_id
203: AND rsl.item_id = p_item_id
204: AND msi1.inventory_item_id = p_item_id

Line 235: , rcv_shipment_lines rsl

231: , 0
232: , msn.current_status
233: , mms.status_code
234: FROM rcv_serials_supply rss
235: , rcv_shipment_lines rsl
236: , mtl_serial_numbers msn
237: , mtl_material_statuses_tl mms
238: WHERE rss.shipment_line_id(+) = rsl.shipment_line_id
239: --BUG 3417870: The RSL.shipment_line_status_code will be FULLY

Line 289: , rcv_shipment_lines rsl

285: , 0
286: , msn.current_status
287: , mms.status_code
288: FROM mtl_serial_numbers msn
289: , rcv_shipment_lines rsl
290: , mtl_material_statuses_tl mms
291: WHERE msn.inventory_item_id = p_item_id
292: AND rsl.shipment_header_id = p_shipment_header_id
293: AND (msn.group_mark_id IS NULL OR msn.group_mark_id = -1)

Line 4041: , rcv_shipment_lines rsl

4037: , 0
4038: , current_status
4039: , mms.status_code
4040: FROM rcv_serials_supply rss
4041: , rcv_shipment_lines rsl
4042: , mtl_serial_numbers msn
4043: , mtl_material_statuses_tl mms
4044: WHERE rss.shipment_line_id(+) = rsl.shipment_line_id
4045: AND nvl(rss.supply_type_code, 'SHIPMENT') = 'SHIPMENT'