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_SERIALS_SUPPLY

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 30: FROM rcv_serials_supply rss

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
32: ,rcv_shipment_headers rsh
33: WHERE rss.supply_type_code = 'SHIPMENT'
34: AND rss.serial_num = SERIAL_NUMBER

Line 223: --shipped serials would be there in rcv_serials_supply and we should be

219: l_src_org_srl_ctrl := 1;
220: END IF;
221:
222: --If the item is serial controlled in the source organization, then the
223: --shipped serials would be there in rcv_serials_supply and we should be
224: --filter the serials in RSS and MSN
225: IF (l_src_org_srl_ctrl <> 1) THEN
226: OPEN x_serial_number FOR
227: SELECT msn.serial_number

Line 234: FROM rcv_serials_supply rss

230: , rss.lot_num
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

Line 3751: * serial number in RCV_SERIALS_SUPPLY that corresponds to the

3747:
3748: /**
3749: * This procedure fetches the Serial Numbers for an item
3750: * inside a LPN that "Resides in Receiving". It uses the
3751: * serial number in RCV_SERIALS_SUPPLY that corresponds to the
3752: * parent transaction.
3753: * This LOV would be called from the Item-based Putaway Drop
3754: * mobile page when the user confirms a quantity lesser than
3755: * the suggested quantity.

Line 3762: * with rcv_serials_supply

3758: * @param p_organization_id Current Organization
3759: * @param p_inventory_item_id Inventory Item
3760: * @param p_lot_number Lot Number
3761: * @param p_txn_header_id Transaction Header ID. This would be used to match
3762: * with rcv_serials_supply
3763: * @param p_serial Serial Number entered on the UI
3764: **/
3765: PROCEDURE get_rcv_lpn_serial_lov(
3766: x_serial_number OUT NOCOPY t_genref

Line 3783: , rcv_serials_supply rss

3779: , 0
3780: , ''
3781: , ''
3782: FROM mtl_serial_numbers msn
3783: , rcv_serials_supply rss
3784: , rcv_supply rs
3785: WHERE msn.lpn_id = p_lpn_id
3786: AND msn.inventory_item_id = p_inventory_item_id
3787: AND msn.current_organization_id = p_organization_id

Line 4040: FROM rcv_serials_supply rss

4036: , lot_number
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