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 CSP_SEC_INVENTORIES

Line 747: l_src_rsc_type csp_sec_inventories.owner_resource_type%TYPE;

743: l_wip_entity_type number;
744: l_FINAL_COMPLETION_FLAG Varchar2(5);
745:
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;

Line 748: l_src_rsc_type_converted csp_sec_inventories.owner_resource_type%TYPE;

744: l_FINAL_COMPLETION_FLAG Varchar2(5);
745:
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;

Line 749: l_src_rsc_id csp_sec_inventories.owner_resource_id%TYPE;

745:
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;

Line 751: l_dest_rsc_type csp_sec_inventories.owner_resource_type%TYPE;

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;
755: l_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;

Line 752: l_dest_rsc_type_converted 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;
755: l_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;
756: l_source_org_code mtl_organizations.organization_code%TYPE;

Line 753: l_dest_rsc_id csp_sec_inventories.owner_resource_id%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;
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;

Line 766: FROM csp_sec_inventories WHERE

762:
763:
764: CURSOR c_source_owner_dtls IS
765: SELECT owner_resource_type, owner_resource_id
766: FROM csp_sec_inventories WHERE
767: organization_id = p_organization_id
768: AND secondary_inventory_name = p_subinventory_code;
769:
770:

Line 773: FROM csp_sec_inventories

769:
770:
771: CURSOR c_dest_owner_dtls IS
772: SELECT owner_resource_type, owner_resource_id
773: FROM csp_sec_inventories
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

Line 3121: from csp_sec_inventories

3117: v_internal_order_req_flag number;
3118:
3119: CURSOR get_auto_receipt_flag(cp_org_id number, cp_subinv varchar2) IS
3120: select autoreceipt_flag
3121: from csp_sec_inventories
3122: where organization_id = cp_org_id
3123: and secondary_inventory_name = cp_subinv;
3124:
3125: CURSOR getStockingSiteType(cp_org_id number, cp_subinv varchar2) IS