DBA Data[Home] [Help]

APPS.WMS_RULE_11 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 563: ,MTL_ITEM_SUB_INVENTORIES misi

559: ,mil.LOCATION_SUGGESTED_UNITS
560: ,mil.rowid
561: from MTL_ITEM_LOCATIONS mil
562: ,MTL_SECONDARY_INVENTORIES msei
563: ,MTL_ITEM_SUB_INVENTORIES misi
564: where mil.organization_id(+) = msei.organization_id
565: and mil.subinventory_code(+) = msei.secondary_inventory_name
566: and NVL(msei.disable_date, sysdate+1) > sysdate
567: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 699: ,MTL_ITEM_SUB_INVENTORIES misi

695: ,mil.LOCATION_SUGGESTED_UNITS
696: ,mil.rowid
697: from MTL_ITEM_LOCATIONS mil
698: ,MTL_SECONDARY_INVENTORIES msei
699: ,MTL_ITEM_SUB_INVENTORIES misi
700: where mil.organization_id(+) = msei.organization_id
701: and mil.subinventory_code(+) = msei.secondary_inventory_name
702: and NVL(msei.disable_date, sysdate+1) > sysdate
703: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 837: ,MTL_ITEM_SUB_INVENTORIES misi

833: ,mil.LOCATION_SUGGESTED_UNITS
834: ,mil.rowid
835: from MTL_ITEM_LOCATIONS mil
836: ,MTL_SECONDARY_INVENTORIES msei
837: ,MTL_ITEM_SUB_INVENTORIES misi
838: where mil.organization_id(+) = msei.organization_id
839: and mil.subinventory_code(+) = msei.secondary_inventory_name
840: and NVL(msei.disable_date, sysdate+1) > sysdate
841: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 977: ,MTL_ITEM_SUB_INVENTORIES misi

973: ,mil.LOCATION_SUGGESTED_UNITS
974: ,mil.rowid
975: from MTL_ITEM_LOCATIONS mil
976: ,MTL_SECONDARY_INVENTORIES msei
977: ,MTL_ITEM_SUB_INVENTORIES misi
978: ,MTL_SECONDARY_LOCATORS msl
979: where mil.organization_id = msei.organization_id
980: and mil.subinventory_code = msei.secondary_inventory_name
981: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1118: ,MTL_ITEM_SUB_INVENTORIES misi

1114: ,mil.LOCATION_SUGGESTED_UNITS
1115: ,mil.rowid
1116: from MTL_ITEM_LOCATIONS mil
1117: ,MTL_SECONDARY_INVENTORIES msei
1118: ,MTL_ITEM_SUB_INVENTORIES misi
1119: ,MTL_SECONDARY_LOCATORS msl
1120: where mil.organization_id = msei.organization_id
1121: and mil.subinventory_code = msei.secondary_inventory_name
1122: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1260: ,MTL_ITEM_SUB_INVENTORIES misi

1256: ,mil.LOCATION_SUGGESTED_UNITS
1257: ,mil.rowid
1258: from MTL_ITEM_LOCATIONS mil
1259: ,MTL_SECONDARY_INVENTORIES msei
1260: ,MTL_ITEM_SUB_INVENTORIES misi
1261: ,MTL_SECONDARY_LOCATORS msl
1262: where mil.organization_id = msei.organization_id
1263: and mil.subinventory_code = msei.secondary_inventory_name
1264: and NVL(msei.disable_date, sysdate+1) > sysdate