DBA Data[Home] [Help]

APPS.WMS_RULE_7 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 532: ,MTL_ITEM_SUB_INVENTORIES misi

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
536: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 659: ,MTL_ITEM_SUB_INVENTORIES misi

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
663: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 788: ,MTL_ITEM_SUB_INVENTORIES misi

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
792: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 919: ,MTL_ITEM_SUB_INVENTORIES misi

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
923: and mil.subinventory_code = msei.secondary_inventory_name

Line 1051: ,MTL_ITEM_SUB_INVENTORIES misi

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
1055: and mil.subinventory_code = msei.secondary_inventory_name

Line 1184: ,MTL_ITEM_SUB_INVENTORIES misi

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
1188: and mil.subinventory_code = msei.secondary_inventory_name