APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_SYSTEM_ITEMS_B

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

Line 832: FROM mtl_system_items_b

828: WHERE responsibility_key = 'SPARES_MANAGEMENT';
829:
830: CURSOR l_cost_of_acct(p_org_id Number,p_item_id Number) IS
831: SELECT cost_of_sales_account,inventory_asset_flag
832: FROM mtl_system_items_b
833: WHERE organization_id = p_org_id
834: AND inventory_item_id = p_item_id;
835:
836: CURSOR l_subinv(p_org_id NUMBER,p_subinv VARCHAR2) IS