DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 2090: FROM mtl_system_items_vl msik, wsh_delivery_details dd, wsh_delivery_assignments da, wsh_new_deliveries nd /* Bug 5581528 */

2086: NVL(msik.SECONDARY_DEFAULT_IND,''),
2087: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2088: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2089: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2090: FROM mtl_system_items_vl msik, wsh_delivery_details dd, wsh_delivery_assignments da, wsh_new_deliveries nd /* Bug 5581528 */
2091: WHERE msik.concatenated_segments LIKE (p_concatenated_segments||l_append)
2092: AND msik.organization_id = p_organization_id
2093: AND msik.inventory_item_id = dd.inventory_item_id
2094: AND nd.delivery_id = p_delivery_id

Line 2150: wsh_delivery_assignments da,

2146: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2147: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2148: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2149: wsh_delivery_details dd,
2150: wsh_delivery_assignments da,
2151: wsh_new_deliveries nd,
2152: mtl_cross_references mcr
2153: WHERE msik.organization_id = p_organization_id
2154: AND msik.inventory_item_id = dd.inventory_item_id