DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on MTL_SUPPLY

Line 635: FROM mtl_supply ms

631: AND sl.to_organization_id = p_organization_id
632: AND sh.receipt_source_code IN ('INTERNAL ORDER','INVENTORY')
633: AND exists
634: (SELECT 'available supply'
635: FROM mtl_supply ms
636: WHERE ms.to_organization_id = p_organization_id
637: AND ms.shipment_header_id = sh.shipment_header_id)
638: -- This was fix for bug 2740648/2752094
639: AND sl.shipment_line_status_code in ('EXPECTED','PARTIALLY RECEIVED')

Line 2066: FROM mtl_supply ms

2062: AND EXISTS
2063: (
2064: SELECT
2065: 'available supply'
2066: FROM mtl_supply ms
2067: WHERE ms.to_organization_id = p_organization_id
2068: AND ms.shipment_header_id = sh.shipment_header_id
2069: )
2070: -- This was fix for bug 2740648/2752094

Line 2692: FROM mtl_supply ms

2688: AND EXISTS
2689: (
2690: SELECT
2691: 'available supply'
2692: FROM mtl_supply ms
2693: WHERE ms.to_organization_id = p_organization_id
2694: AND ms.shipment_header_id = sh.shipment_header_id
2695: )
2696: -- This was fix for bug 2740648/2752094