DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 623: FROM mtl_secondary_inventories

619:
620: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
621: IS
622: SELECT locator_type
623: FROM mtl_secondary_inventories
624: WHERE organization_id = v_org_id
625: AND secondary_inventory_name = v_subinventory;
626: BEGIN
627: IF g_debug <= gme_debug.g_log_procedure THEN

Line 750: FROM mtl_secondary_inventories

746:
747: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
748: IS
749: SELECT locator_type
750: FROM mtl_secondary_inventories
751: WHERE organization_id = v_org_id
752: AND secondary_inventory_name = v_subinventory;
753: BEGIN
754: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1892: FROM mtl_secondary_inventories

1888: v_org_id NUMBER
1889: ,v_subinventory VARCHAR2)
1890: IS
1891: SELECT NVL (locator_type, 1)
1892: FROM mtl_secondary_inventories
1893: WHERE organization_id = v_org_id
1894: AND secondary_inventory_name = v_subinventory;
1895: /* Bug 5441643 Added NVL condition for location control code*/
1896: CURSOR cur_item_details (v_org_id NUMBER, v_inventory_item_id NUMBER)