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.GML_MOBILE_RECEIPT dependencies on RCV_SHIPMENT_LINES

Line 2527: rcv_shipment_lines rsl

2523: 0,
2524: inventory_asset_flag,
2525: outside_operation_flag
2526: from mtl_system_items_kfv msn,
2527: rcv_shipment_lines rsl
2528: WHERE msn.organization_id = p_Organization_Id
2529: and msn.concatenated_segments like p_concatenated_segments
2530: and (msn.purchasing_enabled_flag = 'Y' OR msn.stock_enabled_flag = 'Y')
2531: and rsl.SHIPMENT_HEADER_ID = p_shipmentHeaderID

Line 2569: , rcv_shipment_lines rsl

2565: msi.inventory_asset_flag,
2566: msi.outside_operation_flag
2567: from po_lines_all pol
2568: ,mtl_system_items_kfv msi
2569: , rcv_shipment_lines rsl
2570: where organization_id = p_Organization_Id
2571: and pol.vendor_product_num like p_concatenated_segments
2572: and pol.item_id = msi.inventory_item_id
2573: and pol.vendor_product_num IS NOT NULL

Line 2626: , rcv_shipment_lines rsl

2622: to_char(NULL),
2623: 'N'
2624: from po_lines_all pol
2625: , mtl_units_of_measure mum
2626: , rcv_shipment_lines rsl
2627: -- Bug 2619063, 2614016
2628: -- Modified to select the base uom for the uom class defined on po.
2629: where mum.uom_class = (SELECT mum2.uom_class
2630: FROM mtl_units_of_measure mum2

Line 2672: rcv_shipment_lines rsl,

2668: 0,
2669: msn.inventory_asset_flag,
2670: msn.outside_operation_flag
2671: from mtl_system_items_kfv msn,
2672: rcv_shipment_lines rsl,
2673: mtl_cross_references mcr
2674: WHERE msn.organization_id = p_Organization_Id
2675: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
2676: AND mcr.cross_reference LIKE g_crossref

Line 2825: rcv_shipment_lines rsl , po_req_distributions_all prd

2821: WHERE organization_id = p_Organization_Id
2822: and concatenated_segments like p_concatenated_segments
2823: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2824: and exists (SELECT 1 FROM po_requisition_lines_all prl,
2825: rcv_shipment_lines rsl , po_req_distributions_all prd
2826: WHERE prl.requisition_header_id = p_reqHeaderID
2827: and rsl.item_id = inventory_item_id
2828: and prl.requisition_line_id = rsl.requisition_line_id
2829: and prl.requisition_line_id = prd.requisition_line_id

Line 2875: rcv_shipment_lines rsl , po_req_distributions_all prd

2871: ) )
2872: and mcr.inventory_item_id = msi.inventory_item_id
2873: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2874: and exists (SELECT 1 FROM po_requisition_lines_all prl,
2875: rcv_shipment_lines rsl , po_req_distributions_all prd
2876: WHERE prl.requisition_header_id = p_reqHeaderID
2877: and rsl.item_id = msi.inventory_item_id
2878: and prl.requisition_line_id = rsl.requisition_line_id
2879: and prl.requisition_line_id = prd.requisition_line_id