CST Item Cost Upload
Description
Categories: Enginatics, Upload
Repository: Github
Repository: Github
CST Item Cost Upload
==================
This upload can be used to
- Upload New Item Costs
- Download the current Item Costs, Update, and Upload the amended item costs for a specified Cost Type
- Download the current item Costs from one Source cost type, update, and upload the amended item costs to a different Target Cost Type
Parameters
==========
Target Cost Typ ... more
==================
This upload can be used to
- Upload New Item Costs
- Download the current Item Costs, Update, and Upload the amended item costs for a specified Cost Type
- Download the current item Costs from one Source cost type, update, and upload the amended item costs to a different Target Cost Type
Parameters
==========
Target Cost Typ ... more
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
select x.* from ( select case when nvl2(:p_autopopulate_upload_status,'Y','N') = 'Y' then xxen_upload.action_meaning(xxen_upload.action_update) else null end action_, case when nvl2(:p_autopopulate_upload_status,'Y','N') = 'Y' then xxen_upload.status_meaning(xxen_upload.status_new) else null end status_, case when nvl2(:p_autopopulate_upload_status,'Y','N') = 'Y' then xxen_util.description('U_EXCEL_MSG_VALIDATION_PENDING','XXEN_REPORT_TRANSLATIONS',0) else null end message_, to_number(null) request_id_, null row_id, -- Item cct_t.cost_type target_cost_type, mp.organization_code organization_code, msiv.concatenated_segments item, msiv.description item_description, -- cic.item_cost total_item_cost, xxen_util.meaning(cic.inventory_asset_flag,'SYS_YES_NO',700) inventory_asset, xxen_util.meaning(cic.based_on_rollup_flag,'CST_BONROLLUP_VAL',700) based_on_rollup, coalesce(cic.lot_size,msiv.std_lot_size,1) lot_size, coalesce(cic.shrinkage_rate,msiv.shrinkage_rate,0) shrinkage_rate, -- Item Cost Element Details cdcv.cost_element, cdcv.resource_code sub_element, cdcv.usage_rate_or_amount, cdcv.basis, cdcv.activity, cdcv.activity_units, cdcv.item_units, -- other enterable fields cdcv.operation_seq_num, cdcv.department, -- display only - calculated by Item Cost Import cdcv.basis_factor, cdcv.net_yield_or_shrinkage_factor, cdcv.resource_rate, cdcv.item_cost element_unit_cost, -- Item Cost Summary Amounts cic.material_cost item_material_cost, cic.material_overhead_cost item_material_overhead_cost, cic.resource_cost item_resource_cost, cic.outside_processing_cost item_outside_processing_cost, cic.overhead_cost item_overhead_cost, cic.item_cost item_cost, cic.unburdened_cost item_unburdened_cost, cic.burden_cost item_burden_cost, null last_update_date, null last_updated_by, null creation_date, null created_by, null last_update_login, null group_id, null level_type, null rollup_source_type, null process_flag, null cost_type, null upload_mode -- from cst_cost_types cct_s, cst_cost_types cct_t, cst_item_costs cic, cst_detail_cost_view cdcv, mtl_system_items_vl msiv, mtl_parameters mp where 1=1 and :p_upload_mode = :p_upload_mode and -- cct_s.cost_type = :p_source_cost_type and cct_t.cost_type = :p_target_cost_type and -- cct_s.cost_type_id = cic.cost_type_id and cic.cost_type_id = cdcv.cost_type_id and cic.organization_id = cdcv.organization_id and cic.inventory_item_id = cdcv.inventory_item_id and cic.organization_id = mp.organization_id and cic.organization_id = msiv.organization_id and cic.inventory_item_id = msiv.inventory_item_id and cic.based_on_rollup_flag = decode(:p_exclude_rolled_up_items, 'N', cic.based_on_rollup_flag, 'Y', 2) ¬_use_first_block &report_table_select &report_table_name &report_table_where_clause &success_records &processed_run ) x order by x.target_cost_type, x.organization_code, x.item, x.cost_element, x.sub_element |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Target Cost Type |
|
LOV Oracle | |
Mode |
|
LOV Oracle | |
Auto Populate Upload Columns |
|
LOV | |
Source Cost Type |
|
LOV | |
Organization Code |
|
LOV | |
Item |
|
LOV | |
Exclude Rolled Up Items |
|
LOV Oracle | |
Excluded Item Statuses |
|
LOV |