APPS.WMS_RULE_13 dependencies on MTL_SECONDARY_INVENTORIES

Line 153: ,MTL_SECONDARY_INVENTORIES msei

149: ,mil.SUGGESTED_WEIGHT
150: ,mil.LOCATION_SUGGESTED_UNITS
151: ,mil.rowid
152: from MTL_ITEM_LOCATIONS mil
153: ,MTL_SECONDARY_INVENTORIES msei
154: where mil.organization_id(+) = msei.organization_id
155: and mil.subinventory_code(+) = msei.secondary_inventory_name
156: and NVL(msei.disable_date, sysdate+1) > sysdate
157: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 272: ,MTL_SECONDARY_INVENTORIES msei

268: ,mil.SUGGESTED_WEIGHT
269: ,mil.LOCATION_SUGGESTED_UNITS
270: ,mil.rowid
271: from MTL_ITEM_LOCATIONS mil
272: ,MTL_SECONDARY_INVENTORIES msei
273: where mil.organization_id(+) = msei.organization_id
274: and mil.subinventory_code(+) = msei.secondary_inventory_name
275: and NVL(msei.disable_date, sysdate+1) > sysdate
276: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 390: ,MTL_SECONDARY_INVENTORIES msei

386: ,mil.SUGGESTED_WEIGHT
387: ,mil.LOCATION_SUGGESTED_UNITS
388: ,mil.rowid
389: from MTL_ITEM_LOCATIONS mil
390: ,MTL_SECONDARY_INVENTORIES msei
391: where mil.organization_id(+) = msei.organization_id
392: and mil.subinventory_code(+) = msei.secondary_inventory_name
393: and NVL(msei.disable_date, sysdate+1) > sysdate
394: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 510: ,MTL_SECONDARY_INVENTORIES msei

506: ,mil.SUGGESTED_WEIGHT
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

Line 630: ,MTL_SECONDARY_INVENTORIES msei

626: ,mil.SUGGESTED_WEIGHT
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

Line 752: ,MTL_SECONDARY_INVENTORIES msei

748: ,mil.SUGGESTED_WEIGHT
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

Line 876: ,MTL_SECONDARY_INVENTORIES msei

872: ,mil.SUGGESTED_WEIGHT
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

Line 1001: ,MTL_SECONDARY_INVENTORIES msei

997: ,mil.SUGGESTED_WEIGHT
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

Line 1127: ,MTL_SECONDARY_INVENTORIES msei

1123: ,mil.SUGGESTED_WEIGHT
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