DBA Data[Home] [Help]

APPS.WMS_RULE_11 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 569: ,MTL_ITEM_SUB_INVENTORIES misi

565: ,mil.LOCATION_SUGGESTED_UNITS
566: ,mil.rowid
567: from MTL_ITEM_LOCATIONS mil
568: ,MTL_SECONDARY_INVENTORIES msei
569: ,MTL_ITEM_SUB_INVENTORIES misi
570: where mil.organization_id(+) = msei.organization_id
571: and mil.organization_id=g_organization_id ---bug8425620 8665549
572: and mil.subinventory_code(+) = msei.secondary_inventory_name
573: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 707: ,MTL_ITEM_SUB_INVENTORIES misi

703: ,mil.LOCATION_SUGGESTED_UNITS
704: ,mil.rowid
705: from MTL_ITEM_LOCATIONS mil
706: ,MTL_SECONDARY_INVENTORIES msei
707: ,MTL_ITEM_SUB_INVENTORIES misi
708: where mil.organization_id(+) = msei.organization_id
709: and mil.organization_id=g_organization_id ---bug8425620 8665549
710: and mil.subinventory_code(+) = msei.secondary_inventory_name
711: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 847: ,MTL_ITEM_SUB_INVENTORIES misi

843: ,mil.LOCATION_SUGGESTED_UNITS
844: ,mil.rowid
845: from MTL_ITEM_LOCATIONS mil
846: ,MTL_SECONDARY_INVENTORIES msei
847: ,MTL_ITEM_SUB_INVENTORIES misi
848: where mil.organization_id(+) = msei.organization_id
849: and mil.organization_id=g_organization_id ---bug8425620 8665549
850: and mil.subinventory_code(+) = msei.secondary_inventory_name
851: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 989: ,MTL_ITEM_SUB_INVENTORIES misi

985: ,mil.LOCATION_SUGGESTED_UNITS
986: ,mil.rowid
987: from MTL_ITEM_LOCATIONS mil
988: ,MTL_SECONDARY_INVENTORIES msei
989: ,MTL_ITEM_SUB_INVENTORIES misi
990: ,MTL_SECONDARY_LOCATORS msl
991: where mil.organization_id = msei.organization_id
992: and mil.organization_id=g_organization_id ---bug8425620 8665549
993: and mil.subinventory_code = msei.secondary_inventory_name

Line 1132: ,MTL_ITEM_SUB_INVENTORIES misi

1128: ,mil.LOCATION_SUGGESTED_UNITS
1129: ,mil.rowid
1130: from MTL_ITEM_LOCATIONS mil
1131: ,MTL_SECONDARY_INVENTORIES msei
1132: ,MTL_ITEM_SUB_INVENTORIES misi
1133: ,MTL_SECONDARY_LOCATORS msl
1134: where mil.organization_id = msei.organization_id
1135: and mil.organization_id=g_organization_id ---bug8425620 8665549
1136: and mil.subinventory_code = msei.secondary_inventory_name

Line 1276: ,MTL_ITEM_SUB_INVENTORIES misi

1272: ,mil.LOCATION_SUGGESTED_UNITS
1273: ,mil.rowid
1274: from MTL_ITEM_LOCATIONS mil
1275: ,MTL_SECONDARY_INVENTORIES msei
1276: ,MTL_ITEM_SUB_INVENTORIES misi
1277: ,MTL_SECONDARY_LOCATORS msl
1278: where mil.organization_id = msei.organization_id
1279: and mil.organization_id=g_organization_id ---bug8425620 8665549
1280: and mil.subinventory_code = msei.secondary_inventory_name