DBA Data[Home] [Help]

APPS.WMS_RULE_13 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 511: ,MTL_ITEM_SUB_INVENTORIES misi

507: ,mil.LOCATION_SUGGESTED_UNITS
508: ,mil.rowid
509: from MTL_ITEM_LOCATIONS mil
510: ,MTL_SECONDARY_INVENTORIES msei
511: ,MTL_ITEM_SUB_INVENTORIES misi
512: where mil.organization_id(+) = msei.organization_id
513: and mil.organization_id=g_organization_id ---bug8425620 8665549
514: and mil.subinventory_code(+) = msei.secondary_inventory_name
515: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 631: ,MTL_ITEM_SUB_INVENTORIES misi

627: ,mil.LOCATION_SUGGESTED_UNITS
628: ,mil.rowid
629: from MTL_ITEM_LOCATIONS mil
630: ,MTL_SECONDARY_INVENTORIES msei
631: ,MTL_ITEM_SUB_INVENTORIES misi
632: where mil.organization_id(+) = msei.organization_id
633: and mil.organization_id=g_organization_id ---bug8425620 8665549
634: and mil.subinventory_code(+) = msei.secondary_inventory_name
635: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 753: ,MTL_ITEM_SUB_INVENTORIES misi

749: ,mil.LOCATION_SUGGESTED_UNITS
750: ,mil.rowid
751: from MTL_ITEM_LOCATIONS mil
752: ,MTL_SECONDARY_INVENTORIES msei
753: ,MTL_ITEM_SUB_INVENTORIES misi
754: where mil.organization_id(+) = msei.organization_id
755: and mil.organization_id=g_organization_id ---bug8425620 8665549
756: and mil.subinventory_code(+) = msei.secondary_inventory_name
757: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 877: ,MTL_ITEM_SUB_INVENTORIES misi

873: ,mil.LOCATION_SUGGESTED_UNITS
874: ,mil.rowid
875: from MTL_ITEM_LOCATIONS mil
876: ,MTL_SECONDARY_INVENTORIES msei
877: ,MTL_ITEM_SUB_INVENTORIES misi
878: ,MTL_SECONDARY_LOCATORS msl
879: where mil.organization_id = msei.organization_id
880: and mil.organization_id=g_organization_id ---bug8425620 8665549
881: and mil.subinventory_code = msei.secondary_inventory_name

Line 1002: ,MTL_ITEM_SUB_INVENTORIES misi

998: ,mil.LOCATION_SUGGESTED_UNITS
999: ,mil.rowid
1000: from MTL_ITEM_LOCATIONS mil
1001: ,MTL_SECONDARY_INVENTORIES msei
1002: ,MTL_ITEM_SUB_INVENTORIES misi
1003: ,MTL_SECONDARY_LOCATORS msl
1004: where mil.organization_id = msei.organization_id
1005: and mil.organization_id=g_organization_id ---bug8425620 8665549
1006: and mil.subinventory_code = msei.secondary_inventory_name

Line 1128: ,MTL_ITEM_SUB_INVENTORIES misi

1124: ,mil.LOCATION_SUGGESTED_UNITS
1125: ,mil.rowid
1126: from MTL_ITEM_LOCATIONS mil
1127: ,MTL_SECONDARY_INVENTORIES msei
1128: ,MTL_ITEM_SUB_INVENTORIES misi
1129: ,MTL_SECONDARY_LOCATORS msl
1130: where mil.organization_id = msei.organization_id
1131: and mil.organization_id=g_organization_id ---bug8425620 8665549
1132: and mil.subinventory_code = msei.secondary_inventory_name