DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 7244: FROM mtl_system_items_kfv

7240: and lookup_code = l_item_type;
7241:
7242: CURSOR get_item_number(c_item_id NUMBER, c_org_id NUMBER) IS
7243: select CONCATENATED_SEGMENTS
7244: FROM mtl_system_items_kfv
7245: where inventory_item_id = c_item_id
7246: and organization_id = c_org_id;
7247:
7248: -- bug # 4618899

Line 7391: FROM mtl_system_items_kfv

7387: and lookup_code = l_item_type;
7388:
7389: CURSOR get_item_number(c_item_id NUMBER, c_org_id NUMBER) IS
7390: select CONCATENATED_SEGMENTS
7391: FROM mtl_system_items_kfv
7392: where inventory_item_id = c_item_id
7393: and organization_id = c_org_id;
7394:
7395: -- bug # 4618899

Line 7586: FROM mtl_system_items_kfv

7582: where organization_id = c_org_id;
7583:
7584: CURSOR get_item_number(c_item_id NUMBER, c_org_id NUMBER) IS
7585: select CONCATENATED_SEGMENTS
7586: FROM mtl_system_items_kfv
7587: where inventory_item_id = c_item_id
7588: and organization_id = c_org_id;
7589:
7590: CURSOR get_shpping_method_meaning(c_ship_method varchar2) IS