DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 4702: FROM mtl_system_items_kfv

4698: and lookup_code = l_item_type;
4699:
4700: CURSOR get_item_number(c_item_id NUMBER, c_org_id NUMBER) IS
4701: select CONCATENATED_SEGMENTS
4702: FROM mtl_system_items_kfv
4703: where inventory_item_id = c_item_id
4704: and organization_id = c_org_id;
4705:
4706: -- bug # 4618899

Line 4849: FROM mtl_system_items_kfv

4845: and lookup_code = l_item_type;
4846:
4847: CURSOR get_item_number(c_item_id NUMBER, c_org_id NUMBER) IS
4848: select CONCATENATED_SEGMENTS
4849: FROM mtl_system_items_kfv
4850: where inventory_item_id = c_item_id
4851: and organization_id = c_org_id;
4852:
4853: -- bug # 4618899

Line 5044: FROM mtl_system_items_kfv

5040: where organization_id = c_org_id;
5041:
5042: CURSOR get_item_number(c_item_id NUMBER, c_org_id NUMBER) IS
5043: select CONCATENATED_SEGMENTS
5044: FROM mtl_system_items_kfv
5045: where inventory_item_id = c_item_id
5046: and organization_id = c_org_id;
5047:
5048: CURSOR get_shpping_method_meaning(c_ship_method varchar2) IS