DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 750: l_src_username jtf_rs_resource_extns.user_name%TYPE;

746:
747: l_src_rsc_type csp_sec_inventories.owner_resource_type%TYPE;
748: l_src_rsc_type_converted csp_sec_inventories.owner_resource_type%TYPE;
749: l_src_rsc_id csp_sec_inventories.owner_resource_id%TYPE;
750: l_src_username jtf_rs_resource_extns.user_name%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;

Line 754: l_dest_username jtf_rs_resource_extns.user_name%TYPE;

750: l_src_username jtf_rs_resource_extns.user_name%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;

Line 758: l_dest_source_name jtf_rs_resource_extns.source_name%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;
760: l_uom_desc mtl_item_uoms_view.description%TYPE;
761: itemtype varchar2(20);
762:

Line 759: l_src_source_name jtf_rs_resource_extns.source_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;
760: l_uom_desc mtl_item_uoms_view.description%TYPE;
761: itemtype varchar2(20);
762:
763:

Line 778: SELECT user_name, source_name FROM jtf_rs_resource_extns

774: WHERE organization_id = p_transfer_to_organization
775: AND secondary_inventory_name = p_transfer_to_subinventory;
776:
777: CURSOR c_source_user_name IS
778: SELECT user_name, source_name FROM jtf_rs_resource_extns
779: WHERE resource_id = l_src_rsc_id and category = l_src_rsc_type_converted;
780:
781: CURSOR c_dest_user_name IS
782: SELECT user_name, source_name FROM jtf_rs_resource_extns

Line 782: SELECT user_name, source_name FROM jtf_rs_resource_extns

778: SELECT user_name, source_name FROM jtf_rs_resource_extns
779: WHERE resource_id = l_src_rsc_id and category = l_src_rsc_type_converted;
780:
781: CURSOR c_dest_user_name IS
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