DBA Data[Home] [Help]

APPS.DPP_PURCHASEPRICE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 120: FROM mtl_system_items_kfv msi

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

Line 1037: FROM mtl_system_items_kfv msi

1033:
1034: CURSOR get_item_number_csr(p_inventory_item_id IN NUMBER)
1035: IS
1036: SELECT msi.concatenated_segments
1037: FROM mtl_system_items_kfv msi
1038: WHERE inventory_item_id = p_inventory_item_id
1039: AND ROWNUM = 1;
1040:
1041: -- report card id: 872003