DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 755: l_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;

751: l_dest_rsc_type csp_sec_inventories.owner_resource_type%TYPE;
752: l_dest_rsc_type_converted csp_sec_inventories.owner_resource_type%TYPE;
753: l_dest_rsc_id csp_sec_inventories.owner_resource_id%TYPE;
754: l_dest_username jtf_rs_resource_extns.user_name%TYPE;
755: l_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;
756: l_source_org_code mtl_organizations.organization_code%TYPE;
757: l_dest_org_code mtl_organizations.organization_code%TYPE;
758: l_dest_source_name jtf_rs_resource_extns.source_name%TYPE;
759: l_src_source_name jtf_rs_resource_extns.source_name%TYPE;

Line 786: SELECT concatenated_segments FROM MTL_SYSTEM_ITEMS_B_KFV

782: SELECT user_name, source_name FROM jtf_rs_resource_extns
783: WHERE resource_id = l_dest_rsc_id and category = l_dest_rsc_type_converted;
784:
785: CURSOR c_item_code IS
786: SELECT concatenated_segments FROM MTL_SYSTEM_ITEMS_B_KFV
787: WHERE inventory_item_id=p_inventory_item_id and organization_id=p_organization_id;
788:
789: CURSOR c_source_org_code IS
790: SELECT organization_code FROM mtl_organizations