DBA Data[Home] [Help]

APPS.WMS_RULE_13 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 505: ,MTL_ITEM_SUB_INVENTORIES misi

501: ,mil.LOCATION_SUGGESTED_UNITS
502: ,mil.rowid
503: from MTL_ITEM_LOCATIONS mil
504: ,MTL_SECONDARY_INVENTORIES msei
505: ,MTL_ITEM_SUB_INVENTORIES misi
506: where mil.organization_id(+) = msei.organization_id
507: and mil.subinventory_code(+) = msei.secondary_inventory_name
508: and NVL(msei.disable_date, sysdate+1) > sysdate
509: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 623: ,MTL_ITEM_SUB_INVENTORIES misi

619: ,mil.LOCATION_SUGGESTED_UNITS
620: ,mil.rowid
621: from MTL_ITEM_LOCATIONS mil
622: ,MTL_SECONDARY_INVENTORIES msei
623: ,MTL_ITEM_SUB_INVENTORIES misi
624: where mil.organization_id(+) = msei.organization_id
625: and mil.subinventory_code(+) = msei.secondary_inventory_name
626: and NVL(msei.disable_date, sysdate+1) > sysdate
627: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 743: ,MTL_ITEM_SUB_INVENTORIES misi

739: ,mil.LOCATION_SUGGESTED_UNITS
740: ,mil.rowid
741: from MTL_ITEM_LOCATIONS mil
742: ,MTL_SECONDARY_INVENTORIES msei
743: ,MTL_ITEM_SUB_INVENTORIES misi
744: where mil.organization_id(+) = msei.organization_id
745: and mil.subinventory_code(+) = msei.secondary_inventory_name
746: and NVL(msei.disable_date, sysdate+1) > sysdate
747: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 865: ,MTL_ITEM_SUB_INVENTORIES misi

861: ,mil.LOCATION_SUGGESTED_UNITS
862: ,mil.rowid
863: from MTL_ITEM_LOCATIONS mil
864: ,MTL_SECONDARY_INVENTORIES msei
865: ,MTL_ITEM_SUB_INVENTORIES misi
866: ,MTL_SECONDARY_LOCATORS msl
867: where mil.organization_id = msei.organization_id
868: and mil.subinventory_code = msei.secondary_inventory_name
869: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 988: ,MTL_ITEM_SUB_INVENTORIES misi

984: ,mil.LOCATION_SUGGESTED_UNITS
985: ,mil.rowid
986: from MTL_ITEM_LOCATIONS mil
987: ,MTL_SECONDARY_INVENTORIES msei
988: ,MTL_ITEM_SUB_INVENTORIES misi
989: ,MTL_SECONDARY_LOCATORS msl
990: where mil.organization_id = msei.organization_id
991: and mil.subinventory_code = msei.secondary_inventory_name
992: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1112: ,MTL_ITEM_SUB_INVENTORIES misi

1108: ,mil.LOCATION_SUGGESTED_UNITS
1109: ,mil.rowid
1110: from MTL_ITEM_LOCATIONS mil
1111: ,MTL_SECONDARY_INVENTORIES msei
1112: ,MTL_ITEM_SUB_INVENTORIES misi
1113: ,MTL_SECONDARY_LOCATORS msl
1114: where mil.organization_id = msei.organization_id
1115: and mil.subinventory_code = msei.secondary_inventory_name
1116: and NVL(msei.disable_date, sysdate+1) > sysdate