DBA Data[Home] [Help]

APPS.WMS_RULE_11 dependencies on MTL_SECONDARY_LOCATORS

Line 990: ,MTL_SECONDARY_LOCATORS msl

986: ,mil.rowid
987: from MTL_ITEM_LOCATIONS mil
988: ,MTL_SECONDARY_INVENTORIES msei
989: ,MTL_ITEM_SUB_INVENTORIES misi
990: ,MTL_SECONDARY_LOCATORS msl
991: where mil.organization_id = msei.organization_id
992: and mil.organization_id=g_organization_id ---bug8425620 8665549
993: and mil.subinventory_code = msei.secondary_inventory_name
994: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1133: ,MTL_SECONDARY_LOCATORS msl

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

Line 1277: ,MTL_SECONDARY_LOCATORS msl

1273: ,mil.rowid
1274: from MTL_ITEM_LOCATIONS mil
1275: ,MTL_SECONDARY_INVENTORIES msei
1276: ,MTL_ITEM_SUB_INVENTORIES misi
1277: ,MTL_SECONDARY_LOCATORS msl
1278: where mil.organization_id = msei.organization_id
1279: and mil.organization_id=g_organization_id ---bug8425620 8665549
1280: and mil.subinventory_code = msei.secondary_inventory_name
1281: and NVL(msei.disable_date, sysdate+1) > sysdate