DBA Data[Home] [Help]

APPS.WMS_RULE_10 dependencies on MTL_SECONDARY_LOCATORS

Line 939: ,MTL_SECONDARY_LOCATORS msl

935: ,mil.rowid
936: from MTL_ITEM_LOCATIONS mil
937: ,MTL_SECONDARY_INVENTORIES msei
938: ,MTL_ITEM_SUB_INVENTORIES misi
939: ,MTL_SECONDARY_LOCATORS msl
940: where mil.organization_id = msei.organization_id
941: and mil.organization_id=g_organization_id ---bug8425620 8665549
942: and mil.subinventory_code = msei.secondary_inventory_name
943: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1074: ,MTL_SECONDARY_LOCATORS msl

1070: ,mil.rowid
1071: from MTL_ITEM_LOCATIONS mil
1072: ,MTL_SECONDARY_INVENTORIES msei
1073: ,MTL_ITEM_SUB_INVENTORIES misi
1074: ,MTL_SECONDARY_LOCATORS msl
1075: where mil.organization_id = msei.organization_id
1076: and mil.organization_id=g_organization_id ---bug8425620 8665549
1077: and mil.subinventory_code = msei.secondary_inventory_name
1078: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1210: ,MTL_SECONDARY_LOCATORS msl

1206: ,mil.rowid
1207: from MTL_ITEM_LOCATIONS mil
1208: ,MTL_SECONDARY_INVENTORIES msei
1209: ,MTL_ITEM_SUB_INVENTORIES misi
1210: ,MTL_SECONDARY_LOCATORS msl
1211: where mil.organization_id = msei.organization_id
1212: and mil.organization_id=g_organization_id ---bug8425620 8665549
1213: and mil.subinventory_code = msei.secondary_inventory_name
1214: and NVL(msei.disable_date, sysdate+1) > sysdate