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.CST_EAMCOST_PUB dependencies on WIP_DISCRETE_JOBS

Line 1387: FROM WIP_DISCRETE_JOBS

1383: -- for this asset (eAM Requirements Project - R12)
1384: -- -------------------------------------------------------
1385: SELECT maintenance_object_id, maintenance_object_type
1386: INTO l_maint_obj_id, l_maint_obj_type
1387: FROM WIP_DISCRETE_JOBS
1388: WHERE wip_entity_id = p_wip_entity_id
1389: AND organization_id = p_org_id;
1390:
1391:

Line 2021: -- for wip_discrete_jobs.owning_department_id. If there is still

2017: -- Owning dept = identify from bdr.share_from_dept_id
2018: --
2019: -- Department maintenance cost category.
2020: -- Identify from bom_departments. If null for owning dept, get it
2021: -- for wip_discrete_jobs.owning_department_id. If there is still
2022: -- no maintenance cost cat, get the default cost cat from
2023: -- wip_eam_parameters.
2024: --
2025: -- (anjgupta) If no operation dept is identified(eg if there is no routing)

Line 2102: FROM wip_discrete_jobs

2098: l_stmt_num := 250;
2099: /* get job's owning department */
2100: SELECT owning_department
2101: INTO l_owning_dept_id
2102: FROM wip_discrete_jobs
2103: WHERE wip_entity_id = p_wip_entity_id;
2104: END IF;
2105:
2106: -- Bug 2158026 - if the operation dept is null, then use the

Line 2282: FROM wip_discrete_jobs

2278: INTO l_maint_obj_id,
2279: l_maint_obj_type,
2280: l_inventory_item_id,
2281: l_asset_number
2282: FROM wip_discrete_jobs
2283: WHERE organization_id = p_org_id AND
2284: wip_entity_id = p_entity_id_tab(l_index);
2285:
2286: -- Check if the work order is for a route asset

Line 2857: wip_discrete_jobs wdj

2853: NVL(ccicv.overhead_cost,0))), l_ext_precision) overhead_cost
2854: FROM wip_requirement_operations wro,
2855: cst_cg_item_costs_view ccicv,
2856: mtl_system_items_b msi,
2857: wip_discrete_jobs wdj
2858: WHERE wro.wip_entity_id = p_wip_entity_id
2859: AND wdj.wip_entity_id = wro.wip_entity_id
2860: AND ccicv.inventory_item_id = wro.inventory_item_id
2861: AND ccicv.organization_id = wro.organization_id

Line 3120: from wip_discrete_jobs

3116: resource_account,
3117: outside_processing_account,
3118: overhead_account,
3119: class_code wip_acct_class
3120: from wip_discrete_jobs
3121: where wip_entity_id = p_wip_entity_id;
3122:
3123:
3124: l_period_start_date Date;

Line 3197: FROM wip_discrete_jobs wdj

3193: scheduled_completion_date
3194: INTO l_lot_size,
3195: l_wip_project_id,
3196: l_scheduled_completion_date
3197: FROM wip_discrete_jobs wdj
3198: WHERE wdj.wip_entity_id = p_wip_entity_id;
3199:
3200: l_stmt_num := 16;
3201: -- Get charge asset using API

Line 4252: wip_discrete_jobs wdj,

4248: p_prog_id,
4249: SYSDATE
4250: FROM wip_requirement_operations wro,
4251: cst_cg_item_costs_view ccicv,
4252: wip_discrete_jobs wdj,
4253: mtl_system_items_b msi
4254: WHERE wro.wip_entity_id = p_wip_entity_id
4255: AND ccicv.inventory_item_id = wro.inventory_item_id
4256: AND ccicv.organization_id = wro.organization_id

Line 7032: from wip_discrete_jobs

7028: select decode(l_cost_element, 1, nvl(material_account,-1),
7029: 3, nvl(resource_account, -1),
7030: 4, nvl(outside_processing_account, -1), -1)
7031: into l_wip_acct
7032: from wip_discrete_jobs
7033: where wip_entity_id = direct_item_txn_rec.wip_entity_id;
7034:
7035: l_stmt_num := 100;
7036: -- Insert line for WIP valuation

Line 8232: from wip_discrete_jobs

8228: ---------------------------------------------
8229: l_statement := 50;
8230: select nvl(material_account,-1)
8231: into l_material_account
8232: from wip_discrete_jobs
8233: where wip_entity_id = p_wip_entity_id;
8234: end if;
8235:
8236: x_material_acct := l_material_account;

Line 8524: wip_discrete_jobs wdj,

8520: wdj.project_id,
8521: wdj.task_id,
8522: wdj.maintenance_object_id
8523: from wip_cost_txn_interface wcti,
8524: wip_discrete_jobs wdj,
8525: wip_entities we,
8526: csi_item_instances cii
8527: where wcti.group_id = p_wcti_group_id
8528: and wdj.wip_entity_id = wcti.wip_entity_id

Line 8549: wip_discrete_jobs wdj

8545: msn.gen_object_id
8546: from csi_item_instances cii,
8547: eam_work_order_route ewor,
8548: mtl_serial_numbers msn,
8549: wip_discrete_jobs wdj
8550: where wdj.organization_id = p_org_id
8551: and ewor.wip_entity_id = p_wip_entity_id
8552: and ewor.wip_entity_id = wdj.wip_entity_id
8553: and cii.instance_id = ewor.instance_id

Line 8859: wip_discrete_jobs wdj

8855: p_prog_app_id,
8856: p_prog_id,
8857: SYSDATE
8858: FROM cst_cost_elements cce,
8859: wip_discrete_jobs wdj
8860: where cce.cost_element_id <> 2
8861: and wdj.wip_entity_id = c_route_rec.wip_entity_id
8862: group by cce.cost_element_id,
8863: decode(cce.cost_element_id,

Line 8979: l_parent_wip_entity_id wip_discrete_jobs.parent_wip_entity_id%TYPE;

8975: l_api_version CONSTANT NUMBER := 1.0;
8976: l_stmt_num NUMBER := 0;
8977: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8978:
8979: l_parent_wip_entity_id wip_discrete_jobs.parent_wip_entity_id%TYPE;
8980: l_parent_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8981: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8982: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8983: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;

Line 8980: l_parent_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;

8976: l_stmt_num NUMBER := 0;
8977: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8978:
8979: l_parent_wip_entity_id wip_discrete_jobs.parent_wip_entity_id%TYPE;
8980: l_parent_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8981: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8982: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8983: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8984: l_parent_serial_number csi_item_instances.serial_number%TYPE;

Line 8981: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;

8977: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8978:
8979: l_parent_wip_entity_id wip_discrete_jobs.parent_wip_entity_id%TYPE;
8980: l_parent_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8981: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8982: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8983: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8984: l_parent_serial_number csi_item_instances.serial_number%TYPE;
8985: l_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;

Line 8985: l_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;

8981: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8982: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8983: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8984: l_parent_serial_number csi_item_instances.serial_number%TYPE;
8985: l_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8986: l_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8987: l_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8988: l_serial_number csi_item_instances.serial_number%TYPE;
8989: BEGIN

Line 8986: l_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;

8982: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8983: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8984: l_parent_serial_number csi_item_instances.serial_number%TYPE;
8985: l_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8986: l_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8987: l_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8988: l_serial_number csi_item_instances.serial_number%TYPE;
8989: BEGIN
8990: -- Standard call to check for call compatibility

Line 9029: FROM wip_discrete_jobs wdj,

9025: l_maint_object_type,
9026: l_maint_object_id,
9027: l_inventory_item_id,
9028: l_serial_number
9029: FROM wip_discrete_jobs wdj,
9030: wip_discrete_jobs pwdj,
9031: csi_item_instances cii,
9032: csi_item_instances pcii
9033: WHERE wdj.wip_entity_id = p_wip_entity_id

Line 9030: wip_discrete_jobs pwdj,

9026: l_maint_object_id,
9027: l_inventory_item_id,
9028: l_serial_number
9029: FROM wip_discrete_jobs wdj,
9030: wip_discrete_jobs pwdj,
9031: csi_item_instances cii,
9032: csi_item_instances pcii
9033: WHERE wdj.wip_entity_id = p_wip_entity_id
9034: AND cii.instance_id (+) = wdj.maintenance_object_id

Line 11481: , wip_discrete_jobs wdj

11477: , wac.encumbrance_account wac_encumbrance_account
11478: , msi.encumbrance_account msi_encumbrance_account
11479: , mp.encumbrance_account mp_encumbrance_account
11480: FROM wip_entities we
11481: , wip_discrete_jobs wdj
11482: , wip_accounting_classes wac
11483: , mtl_system_items msi
11484: , mtl_parameters mp
11485: WHERE we.wip_entity_id = p_wip_entity_id