DBA Data[Home] [Help]

APPS.WMS_RULE_3 dependencies on MTL_SYSTEM_ITEMS

Line 88: ,MTL_SYSTEM_ITEMS msi

84: ,base.LOCATOR_ID
85: ,msi.PRIMARY_UOM_CODE
86: ,mptdtv.TRANSACTION_UOM ) order_by_string
87: from MTL_LOT_NUMBERS mln
88: ,MTL_SYSTEM_ITEMS msi
89: ,WMS_TRX_DETAILS_TMP_V mptdtv
90: ,(
91: select msn.current_organization_id organization_id
92: ,msn.inventory_item_id

Line 195: ,MTL_SYSTEM_ITEMS msi

191: ,base.LOCATOR_ID
192: ,msi.PRIMARY_UOM_CODE
193: ,mptdtv.TRANSACTION_UOM ) order_by_string
194: from MTL_LOT_NUMBERS mln
195: ,MTL_SYSTEM_ITEMS msi
196: ,WMS_TRX_DETAILS_TMP_V mptdtv
197: ,(
198: select msn.current_organization_id organization_id
199: ,msn.inventory_item_id

Line 331: ,MTL_SYSTEM_ITEMS msi

327: ,base.LOCATOR_ID
328: ,msi.PRIMARY_UOM_CODE
329: ,mptdtv.TRANSACTION_UOM ) order_by_string
330: from MTL_LOT_NUMBERS mln
331: ,MTL_SYSTEM_ITEMS msi
332: ,WMS_TRX_DETAILS_TMP_V mptdtv
333: ,(
334: select msn.current_organization_id organization_id
335: ,msn.inventory_item_id

Line 464: ,MTL_SYSTEM_ITEMS msi

460: ,base.LOCATOR_ID
461: ,msi.PRIMARY_UOM_CODE
462: ,mptdtv.TRANSACTION_UOM ) order_by_string
463: from MTL_LOT_NUMBERS mln
464: ,MTL_SYSTEM_ITEMS msi
465: ,WMS_TRX_DETAILS_TMP_V mptdtv
466: ,(
467: SELECT x.organization_id organization_id
468: ,x.inventory_item_id inventory_item_id