APPS.WMS_RULE_7 dependencies on MTL_SECONDARY_INVENTORIES

Line 153: ,MTL_SECONDARY_INVENTORIES msei

149: ,mil.SUGGESTED_WEIGHT
150: ,mil.LOCATION_SUGGESTED_UNITS
151: ,mil.rowid
152: from MTL_ITEM_LOCATIONS mil
153: ,MTL_SECONDARY_INVENTORIES msei
154: where mil.organization_id(+) = msei.organization_id
155: and mil.subinventory_code(+) = msei.secondary_inventory_name
156: and NVL(msei.disable_date, sysdate+1) > sysdate
157: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 279: ,MTL_SECONDARY_INVENTORIES msei

275: ,mil.SUGGESTED_WEIGHT
276: ,mil.LOCATION_SUGGESTED_UNITS
277: ,mil.rowid
278: from MTL_ITEM_LOCATIONS mil
279: ,MTL_SECONDARY_INVENTORIES msei
280: where mil.organization_id(+) = msei.organization_id
281: and mil.subinventory_code(+) = msei.secondary_inventory_name
282: and NVL(msei.disable_date, sysdate+1) > sysdate
283: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 404: ,MTL_SECONDARY_INVENTORIES msei

400: ,mil.SUGGESTED_WEIGHT
401: ,mil.LOCATION_SUGGESTED_UNITS
402: ,mil.rowid
403: from MTL_ITEM_LOCATIONS mil
404: ,MTL_SECONDARY_INVENTORIES msei
405: where mil.organization_id(+) = msei.organization_id
406: and mil.subinventory_code(+) = msei.secondary_inventory_name
407: and NVL(msei.disable_date, sysdate+1) > sysdate
408: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 531: ,MTL_SECONDARY_INVENTORIES msei

527: ,mil.SUGGESTED_WEIGHT
528: ,mil.LOCATION_SUGGESTED_UNITS
529: ,mil.rowid
530: from MTL_ITEM_LOCATIONS mil
531: ,MTL_SECONDARY_INVENTORIES msei
532: ,MTL_ITEM_SUB_INVENTORIES misi
533: where mil.organization_id(+) = msei.organization_id
534: and mil.organization_id=g_organization_id ---bug8425620 8665549
535: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 658: ,MTL_SECONDARY_INVENTORIES msei

654: ,mil.SUGGESTED_WEIGHT
655: ,mil.LOCATION_SUGGESTED_UNITS
656: ,mil.rowid
657: from MTL_ITEM_LOCATIONS mil
658: ,MTL_SECONDARY_INVENTORIES msei
659: ,MTL_ITEM_SUB_INVENTORIES misi
660: where mil.organization_id(+) = msei.organization_id
661: and mil.organization_id=g_organization_id ---bug8425620 8665549
662: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 787: ,MTL_SECONDARY_INVENTORIES msei

783: ,mil.SUGGESTED_WEIGHT
784: ,mil.LOCATION_SUGGESTED_UNITS
785: ,mil.rowid
786: from MTL_ITEM_LOCATIONS mil
787: ,MTL_SECONDARY_INVENTORIES msei
788: ,MTL_ITEM_SUB_INVENTORIES misi
789: where mil.organization_id(+) = msei.organization_id
790: and mil.organization_id=g_organization_id ---bug8425620 8665549
791: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 918: ,MTL_SECONDARY_INVENTORIES msei

914: ,mil.SUGGESTED_WEIGHT
915: ,mil.LOCATION_SUGGESTED_UNITS
916: ,mil.rowid
917: from MTL_ITEM_LOCATIONS mil
918: ,MTL_SECONDARY_INVENTORIES msei
919: ,MTL_ITEM_SUB_INVENTORIES misi
920: ,MTL_SECONDARY_LOCATORS msl
921: where mil.organization_id = msei.organization_id
922: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 1050: ,MTL_SECONDARY_INVENTORIES msei

1046: ,mil.SUGGESTED_WEIGHT
1047: ,mil.LOCATION_SUGGESTED_UNITS
1048: ,mil.rowid
1049: from MTL_ITEM_LOCATIONS mil
1050: ,MTL_SECONDARY_INVENTORIES msei
1051: ,MTL_ITEM_SUB_INVENTORIES misi
1052: ,MTL_SECONDARY_LOCATORS msl
1053: where mil.organization_id = msei.organization_id
1054: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 1183: ,MTL_SECONDARY_INVENTORIES msei

1179: ,mil.SUGGESTED_WEIGHT
1180: ,mil.LOCATION_SUGGESTED_UNITS
1181: ,mil.rowid
1182: from MTL_ITEM_LOCATIONS mil
1183: ,MTL_SECONDARY_INVENTORIES msei
1184: ,MTL_ITEM_SUB_INVENTORIES misi
1185: ,MTL_SECONDARY_LOCATORS msl
1186: where mil.organization_id = msei.organization_id
1187: and mil.organization_id=g_organization_id ---bug8425620 8665549