DBA Data[Home] [Help]

APPS.DPP_PURCHASEPRICE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 119: FROM mtl_system_items_kfv msi

115:
116: CURSOR get_item_number_csr (p_inventory_item_id IN NUMBER)
117: IS
118: SELECT concatenated_segments item_number
119: FROM mtl_system_items_kfv msi
120: WHERE inventory_item_id = p_inventory_item_id
121: AND ROWNUM = 1;
122:
123: BEGIN

Line 1046: FROM mtl_system_items_kfv msi

1042:
1043: CURSOR get_item_number_csr(p_inventory_item_id IN NUMBER)
1044: IS
1045: SELECT msi.concatenated_segments
1046: FROM mtl_system_items_kfv msi
1047: WHERE inventory_item_id = p_inventory_item_id
1048: AND ROWNUM = 1;
1049:
1050: -- report card id: 872003