DBA Data[Home] [Help]

APPS.WMS_RULE_13 dependencies on MTL_SECONDARY_LOCATORS

Line 878: ,MTL_SECONDARY_LOCATORS msl

874: ,mil.rowid
875: from MTL_ITEM_LOCATIONS mil
876: ,MTL_SECONDARY_INVENTORIES msei
877: ,MTL_ITEM_SUB_INVENTORIES misi
878: ,MTL_SECONDARY_LOCATORS msl
879: where mil.organization_id = msei.organization_id
880: and mil.organization_id=g_organization_id ---bug8425620 8665549
881: and mil.subinventory_code = msei.secondary_inventory_name
882: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1003: ,MTL_SECONDARY_LOCATORS msl

999: ,mil.rowid
1000: from MTL_ITEM_LOCATIONS mil
1001: ,MTL_SECONDARY_INVENTORIES msei
1002: ,MTL_ITEM_SUB_INVENTORIES misi
1003: ,MTL_SECONDARY_LOCATORS msl
1004: where mil.organization_id = msei.organization_id
1005: and mil.organization_id=g_organization_id ---bug8425620 8665549
1006: and mil.subinventory_code = msei.secondary_inventory_name
1007: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1129: ,MTL_SECONDARY_LOCATORS msl

1125: ,mil.rowid
1126: from MTL_ITEM_LOCATIONS mil
1127: ,MTL_SECONDARY_INVENTORIES msei
1128: ,MTL_ITEM_SUB_INVENTORIES misi
1129: ,MTL_SECONDARY_LOCATORS msl
1130: where mil.organization_id = msei.organization_id
1131: and mil.organization_id=g_organization_id ---bug8425620 8665549
1132: and mil.subinventory_code = msei.secondary_inventory_name
1133: and NVL(msei.disable_date, sysdate+1) > sysdate