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_MGD_MVT_STATS_PROC dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 1535: FROM wsh_delivery_details_ob_grp_v

1531: IF l_movement_transaction.picking_line_detail_id IS NOT NULL
1532: THEN
1533: SELECT mvt_stat_status
1534: INTO l_mvt_stat_status
1535: FROM wsh_delivery_details_ob_grp_v
1536: WHERE delivery_detail_id = l_movement_transaction.picking_line_detail_id;
1537: END IF;
1538:
1539: IF (l_mvt_stat_status IS NOT NULL

Line 2504: , wsh_delivery_details_ob_grp_v wdd

2500: MAX(oola.line_id)
2501: , MAX(wdd.delivery_detail_id) picking_line_detail_id
2502: FROM
2503: oe_order_lines_all oola
2504: , wsh_delivery_details_ob_grp_v wdd
2505: WHERE oola.order_source_id = 10 --combine 1st and 2nd condition to use index 11
2506: AND oola.orig_sys_document_ref = l_req_number
2507: AND oola.source_document_line_id = l_movement_transaction.requisition_line_id
2508: AND oola.line_id = wdd.source_line_id

Line 2523: , wsh_delivery_details_ob_grp_v wdd

2519: oola.line_id
2520: , wdd.delivery_detail_id picking_line_detail_id
2521: FROM
2522: oe_order_lines_all oola
2523: , wsh_delivery_details_ob_grp_v wdd
2524: , rcv_transactions rcv
2525: , rcv_shipment_lines rsl
2526: , mtl_material_transactions mmt
2527: WHERE oola.order_source_id = 10 --combine 1st and 2nd condition to use index 11

Line 2553: wsh_delivery_details_ob_grp_v wdd

2549: CURSOR shipping_org IS
2550: SELECT
2551: wdd.organization_id shipping_organization_id
2552: FROM
2553: wsh_delivery_details_ob_grp_v wdd
2554: WHERE wdd.delivery_detail_id=l_movement_transaction.picking_line_detail_id;
2555:
2556: BEGIN
2557: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)