eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_ORGANIZATIONS

Line 756: l_source_org_code mtl_organizations.organization_code%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;
760: l_uom_desc mtl_item_uoms_view.description%TYPE;

Line 757: l_dest_org_code mtl_organizations.organization_code%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;
760: l_uom_desc mtl_item_uoms_view.description%TYPE;
761: itemtype varchar2(20);

Line 790: SELECT organization_code FROM mtl_organizations

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
791: WHERE Organization_id = p_organization_id;
792:
793: CURSOR c_dest_org_code IS
794: SELECT organization_code FROM mtl_organizations

Line 794: SELECT organization_code FROM mtl_organizations

790: SELECT organization_code FROM mtl_organizations
791: WHERE Organization_id = p_organization_id;
792:
793: CURSOR c_dest_org_code IS
794: SELECT organization_code FROM mtl_organizations
795: WHERE Organization_id = p_transfer_to_organization;
796:
797: CURSOR c_uom_desc IS
798: SELECT description FROM mtl_item_uoms_view