DBA Data[Home] [Help]

APPS.WMS_RULE_4 dependencies on MTL_SYSTEM_ITEMS

Line 82: ,MTL_SYSTEM_ITEMS msi

78: ,base.grade_code
79: ,NULL consist_string
80: ,msn.SERIAL_NUMBER order_by_string
81: from MTL_SERIAL_NUMBERS msn
82: ,MTL_SYSTEM_ITEMS msi
83: ,WMS_TRX_DETAILS_TMP_V mptdtv
84: ,(
85: select msn.current_organization_id organization_id
86: ,msn.inventory_item_id

Line 176: ,MTL_SYSTEM_ITEMS msi

172: ,base.grade_code
173: ,NULL consist_string
174: ,msn.SERIAL_NUMBER order_by_string
175: from MTL_SERIAL_NUMBERS msn
176: ,MTL_SYSTEM_ITEMS msi
177: ,WMS_TRX_DETAILS_TMP_V mptdtv
178: ,(
179: select msn.current_organization_id organization_id
180: ,msn.inventory_item_id

Line 287: ,MTL_SYSTEM_ITEMS msi

283: ,base.grade_code
284: ,NULL consist_string
285: ,msn.SERIAL_NUMBER order_by_string
286: from MTL_SERIAL_NUMBERS msn
287: ,MTL_SYSTEM_ITEMS msi
288: ,WMS_TRX_DETAILS_TMP_V mptdtv
289: ,(
290: select msn.current_organization_id organization_id
291: ,msn.inventory_item_id

Line 395: ,MTL_SYSTEM_ITEMS msi

391: ,base.grade_code
392: ,NULL consist_string
393: ,msn.SERIAL_NUMBER order_by_string
394: from MTL_SERIAL_NUMBERS msn
395: ,MTL_SYSTEM_ITEMS msi
396: ,WMS_TRX_DETAILS_TMP_V mptdtv
397: ,(
398: SELECT x.organization_id organization_id
399: ,x.inventory_item_id inventory_item_id