DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on WSH_NEW_DELIVERIES

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

1959: NVL(msik.SECONDARY_DEFAULT_IND,''),
1960: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1961: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1962: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1963: FROM mtl_system_items_vl msik, wsh_delivery_details dd, wsh_delivery_assignments da, wsh_new_deliveries nd /* Bug 5581528 */
1964: WHERE msik.concatenated_segments LIKE (p_concatenated_segments)
1965: AND msik.organization_id = p_organization_id
1966: AND msik.inventory_item_id = dd.inventory_item_id
1967: AND nd.delivery_id = p_delivery_id

Line 2023: wsh_new_deliveries nd,

2019: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2020: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2021: wsh_delivery_details dd,
2022: wsh_delivery_assignments da,
2023: wsh_new_deliveries nd,
2024: mtl_cross_references mcr
2025: WHERE msik.organization_id = p_organization_id
2026: AND msik.inventory_item_id = dd.inventory_item_id
2027: AND nd.delivery_id = p_delivery_id