APPS.WSH_DELIVERY_DETAILS_INV dependencies on MTL_SECONDARY_INVENTORIES

Line 646: FROM mtl_secondary_inventories msi

642: CURSOR Get_location_control_code(cv_subinventory VARCHAR2
643: ,cv_organization_id NUMBER)
644: IS
645: SELECT locator_type
646: FROM mtl_secondary_inventories msi
647: WHERE msi.secondary_inventory_name = cv_subinventory
648: AND msi.organization_id = cv_organization_id;
649: --Bug#13949115 end
650: l_rev_flag VARCHAR2(3);

Line 824: -- so directly taking the location_control_code from mtl_secondary_inventories

820: IF l_subinv IS NOT NULL
821: THEN
822: -- wms subinventory always be locator controlled
823: -- and the locator can be either pre specified( loc control code 2) or dynamic ( loc control code 3)
824: -- so directly taking the location_control_code from mtl_secondary_inventories
825: IF l_debug_on THEN
826: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching the location_control_code from sub inventory');
827: END IF;
828:

Line 1679: mtl_secondary_inventories mtlsub

1675:
1676: CURSOR Default_Sub IS
1677: SELECT mtlsub.secondary_inventory_name
1678: FROM mtl_item_sub_defaults mtlisd,
1679: mtl_secondary_inventories mtlsub
1680: WHERE mtlisd.inventory_item_id = p_inv_item_id
1681: AND mtlisd.organization_id = p_org_id
1682: AND mtlisd.default_type = 1
1683: AND mtlsub.organization_id = mtlisd.organization_id