DBA Data[Home] [Help]

APPS.WMS_RULE_10 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 542: ,MTL_ITEM_SUB_INVENTORIES misi

538: ,mil.LOCATION_SUGGESTED_UNITS
539: ,mil.rowid
540: from MTL_ITEM_LOCATIONS mil
541: ,MTL_SECONDARY_INVENTORIES msei
542: ,MTL_ITEM_SUB_INVENTORIES misi
543: where mil.organization_id(+) = msei.organization_id
544: and mil.organization_id=g_organization_id ---bug8425620 8665549
545: and mil.subinventory_code(+) = msei.secondary_inventory_name
546: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 672: ,MTL_ITEM_SUB_INVENTORIES misi

668: ,mil.LOCATION_SUGGESTED_UNITS
669: ,mil.rowid
670: from MTL_ITEM_LOCATIONS mil
671: ,MTL_SECONDARY_INVENTORIES msei
672: ,MTL_ITEM_SUB_INVENTORIES misi
673: where mil.organization_id(+) = msei.organization_id
674: and mil.organization_id=g_organization_id ---bug8425620 8665549
675: and mil.subinventory_code(+) = msei.secondary_inventory_name
676: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 804: ,MTL_ITEM_SUB_INVENTORIES misi

800: ,mil.LOCATION_SUGGESTED_UNITS
801: ,mil.rowid
802: from MTL_ITEM_LOCATIONS mil
803: ,MTL_SECONDARY_INVENTORIES msei
804: ,MTL_ITEM_SUB_INVENTORIES misi
805: where mil.organization_id(+) = msei.organization_id
806: and mil.organization_id=g_organization_id ---bug8425620 8665549
807: and mil.subinventory_code(+) = msei.secondary_inventory_name
808: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 938: ,MTL_ITEM_SUB_INVENTORIES misi

934: ,mil.LOCATION_SUGGESTED_UNITS
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

Line 1073: ,MTL_ITEM_SUB_INVENTORIES misi

1069: ,mil.LOCATION_SUGGESTED_UNITS
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

Line 1209: ,MTL_ITEM_SUB_INVENTORIES misi

1205: ,mil.LOCATION_SUGGESTED_UNITS
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