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 1165: FROM WIP_DISCRETE_JOBS

1161: -- for this asset (eAM Requirements Project - R12)
1162: -- -------------------------------------------------------
1163: SELECT maintenance_object_id, maintenance_object_type
1164: INTO l_maint_obj_id, l_maint_obj_type
1165: FROM WIP_DISCRETE_JOBS
1166: WHERE wip_entity_id = p_wip_entity_id
1167: AND organization_id = p_org_id;
1168:
1169:

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

1795: -- Owning dept = identify from bdr.share_from_dept_id
1796: --
1797: -- Department maintenance cost category.
1798: -- Identify from bom_departments. If null for owning dept, get it
1799: -- for wip_discrete_jobs.owning_department_id. If there is still
1800: -- no maintenance cost cat, get the default cost cat from
1801: -- wip_eam_parameters.
1802: --
1803: -- (anjgupta) If no operation dept is identified(eg if there is no routing)

Line 1880: FROM wip_discrete_jobs

1876: l_stmt_num := 250;
1877: /* get job's owning department */
1878: SELECT owning_department
1879: INTO l_owning_dept_id
1880: FROM wip_discrete_jobs
1881: WHERE wip_entity_id = p_wip_entity_id;
1882: END IF;
1883:
1884: -- Bug 2158026 - if the operation dept is null, then use the

Line 2060: FROM wip_discrete_jobs

2056: INTO l_maint_obj_id,
2057: l_maint_obj_type,
2058: l_inventory_item_id,
2059: l_asset_number
2060: FROM wip_discrete_jobs
2061: WHERE organization_id = p_org_id AND
2062: wip_entity_id = p_entity_id_tab(l_index);
2063:
2064: -- Check if the work order is for a route asset

Line 2635: wip_discrete_jobs wdj

2631: NVL(ccicv.overhead_cost,0))), l_ext_precision) overhead_cost
2632: FROM wip_requirement_operations wro,
2633: cst_cg_item_costs_view ccicv,
2634: mtl_system_items_b msi,
2635: wip_discrete_jobs wdj
2636: WHERE wro.wip_entity_id = p_wip_entity_id
2637: AND wdj.wip_entity_id = wro.wip_entity_id
2638: AND ccicv.inventory_item_id = wro.inventory_item_id
2639: AND ccicv.organization_id = wro.organization_id

Line 2898: from wip_discrete_jobs

2894: resource_account,
2895: outside_processing_account,
2896: overhead_account,
2897: class_code wip_acct_class
2898: from wip_discrete_jobs
2899: where wip_entity_id = p_wip_entity_id;
2900:
2901:
2902: l_period_start_date Date;

Line 2975: FROM wip_discrete_jobs wdj

2971: scheduled_completion_date
2972: INTO l_lot_size,
2973: l_wip_project_id,
2974: l_scheduled_completion_date
2975: FROM wip_discrete_jobs wdj
2976: WHERE wdj.wip_entity_id = p_wip_entity_id;
2977:
2978: l_stmt_num := 16;
2979: -- Get charge asset using API

Line 4030: wip_discrete_jobs wdj,

4026: p_prog_id,
4027: SYSDATE
4028: FROM wip_requirement_operations wro,
4029: cst_cg_item_costs_view ccicv,
4030: wip_discrete_jobs wdj,
4031: mtl_system_items_b msi
4032: WHERE wro.wip_entity_id = p_wip_entity_id
4033: AND ccicv.inventory_item_id = wro.inventory_item_id
4034: AND ccicv.organization_id = wro.organization_id

Line 6624: from wip_discrete_jobs

6620: select decode(l_cost_element, 1, nvl(material_account,-1),
6621: 3, nvl(resource_account, -1),
6622: 4, nvl(outside_processing_account, -1), -1)
6623: into l_wip_acct
6624: from wip_discrete_jobs
6625: where wip_entity_id = direct_item_txn_rec.wip_entity_id;
6626:
6627: l_stmt_num := 100;
6628: -- Insert line for WIP valuation

Line 7659: from wip_discrete_jobs

7655: ---------------------------------------------
7656: l_statement := 50;
7657: select nvl(material_account,-1)
7658: into l_material_account
7659: from wip_discrete_jobs
7660: where wip_entity_id = p_wip_entity_id;
7661: end if;
7662:
7663: x_material_acct := l_material_account;

Line 7951: wip_discrete_jobs wdj,

7947: wdj.project_id,
7948: wdj.task_id,
7949: wdj.maintenance_object_id
7950: from wip_cost_txn_interface wcti,
7951: wip_discrete_jobs wdj,
7952: wip_entities we,
7953: csi_item_instances cii
7954: where wcti.group_id = p_wcti_group_id
7955: and wdj.wip_entity_id = wcti.wip_entity_id

Line 7976: wip_discrete_jobs wdj

7972: msn.gen_object_id
7973: from csi_item_instances cii,
7974: eam_work_order_route ewor,
7975: mtl_serial_numbers msn,
7976: wip_discrete_jobs wdj
7977: where wdj.organization_id = p_org_id
7978: and ewor.wip_entity_id = p_wip_entity_id
7979: and ewor.wip_entity_id = wdj.wip_entity_id
7980: and cii.instance_id = ewor.instance_id

Line 8286: wip_discrete_jobs wdj

8282: p_prog_app_id,
8283: p_prog_id,
8284: SYSDATE
8285: FROM cst_cost_elements cce,
8286: wip_discrete_jobs wdj
8287: where cce.cost_element_id <> 2
8288: and wdj.wip_entity_id = c_route_rec.wip_entity_id
8289: group by cce.cost_element_id,
8290: decode(cce.cost_element_id,

Line 8406: l_parent_wip_entity_id wip_discrete_jobs.parent_wip_entity_id%TYPE;

8402: l_api_version CONSTANT NUMBER := 1.0;
8403: l_stmt_num NUMBER := 0;
8404: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8405:
8406: l_parent_wip_entity_id wip_discrete_jobs.parent_wip_entity_id%TYPE;
8407: l_parent_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8408: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8409: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8410: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;

Line 8407: l_parent_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;

8403: l_stmt_num NUMBER := 0;
8404: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8405:
8406: l_parent_wip_entity_id wip_discrete_jobs.parent_wip_entity_id%TYPE;
8407: l_parent_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8408: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8409: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8410: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8411: l_parent_serial_number csi_item_instances.serial_number%TYPE;

Line 8408: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;

8404: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8405:
8406: l_parent_wip_entity_id wip_discrete_jobs.parent_wip_entity_id%TYPE;
8407: l_parent_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8408: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8409: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8410: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8411: l_parent_serial_number csi_item_instances.serial_number%TYPE;
8412: l_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;

Line 8412: l_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;

8408: l_parent_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8409: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8410: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8411: l_parent_serial_number csi_item_instances.serial_number%TYPE;
8412: l_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8413: l_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8414: l_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8415: l_serial_number csi_item_instances.serial_number%TYPE;
8416: BEGIN

Line 8413: l_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;

8409: l_parent_network_asset_flag csi_item_instances.network_asset_flag%TYPE;
8410: l_parent_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8411: l_parent_serial_number csi_item_instances.serial_number%TYPE;
8412: l_maint_object_type wip_discrete_jobs.maintenance_object_type%TYPE;
8413: l_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8414: l_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8415: l_serial_number csi_item_instances.serial_number%TYPE;
8416: BEGIN
8417: -- Standard call to check for call compatibility

Line 8456: FROM wip_discrete_jobs wdj,

8452: l_maint_object_type,
8453: l_maint_object_id,
8454: l_inventory_item_id,
8455: l_serial_number
8456: FROM wip_discrete_jobs wdj,
8457: wip_discrete_jobs pwdj,
8458: csi_item_instances cii,
8459: csi_item_instances pcii
8460: WHERE wdj.wip_entity_id = p_wip_entity_id

Line 8457: wip_discrete_jobs pwdj,

8453: l_maint_object_id,
8454: l_inventory_item_id,
8455: l_serial_number
8456: FROM wip_discrete_jobs wdj,
8457: wip_discrete_jobs pwdj,
8458: csi_item_instances cii,
8459: csi_item_instances pcii
8460: WHERE wdj.wip_entity_id = p_wip_entity_id
8461: AND cii.instance_id (+) = wdj.maintenance_object_id