DBA Data[Home] [Help]

APPS.PO_COMPARE_REVISIONS dependencies on MTL_SYSTEM_ITEMS

Line 113: * MTL_SYSTEM_ITEMS_KFV view.

109: * Resolves the item number.
110: *
111: * ARGUMENTS
112: * p_item_id Unique identifier for item number in
113: * MTL_SYSTEM_ITEMS_KFV view.
114: *
115: * NOTES
116: * Return NULL if an error occurs.
117: *

Line 137: mtl_system_items msi,

133:
134: SELECT icx_util.item_flex_seg( msi.rowid )
135: INTO v_item_num
136: FROM
137: mtl_system_items msi,
138: financials_system_parameters fsp
139: WHERE
140: p_item_id = msi.inventory_item_id (+)
141: AND fsp.inventory_organization_id = NVL(