APPS.CST_PACEAMCOST_GRP dependencies on WIP_DISCRETE_JOBS

Line 263: FROM wip_discrete_jobs wdj,

259: SYSDATE,
260: l_user_id,
261: l_request_id,
262: SYSDATE
263: FROM wip_discrete_jobs wdj,
264: wip_entities we,
265: cst_cost_group_assignments ccga
266: WHERE wdj.wip_entity_id = we.wip_entity_id
267: AND wdj.organization_id = ccga.organization_id

Line 306: FROM wip_discrete_jobs wdj

302: AND we.entity_type = p_entity_type
303: )
304: AND NVL(es.estimation_status,1) > 0
305: AND EXISTS ( SELECT 'Status Check for WO'
306: FROM wip_discrete_jobs wdj
307: WHERE wdj.status_type IN (1,3,4,6,17)
308: AND wdj.wip_entity_id = nvl(p_wip_entity_id,wdj.wip_entity_id)
309: AND wdj.wip_entity_id = es.wip_entity_id
310: )

Line 348: FROM wip_discrete_jobs wdj, wip_entities we

344: SYSDATE,
345: l_user_id,
346: l_request_id,
347: SYSDATE
348: FROM wip_discrete_jobs wdj, wip_entities we
349: WHERE wdj.wip_entity_id = we.wip_entity_id
350: AND we.entity_type = 6
351: AND NOT EXISTS
352: ( SELECT 'Not existing jobs'

Line 377: FROM wip_discrete_jobs wdj

373: AND p_job_option = 2
374: AND es.wip_entity_id = p_wip_entity_id
375: AND NVL(es.estimation_status,1) > 0
376: AND EXISTS ( SELECT 'Status Check for WO'
377: FROM wip_discrete_jobs wdj
378: WHERE wdj.status_type IN (1,3,4,6,17)
379: AND wdj.wip_entity_id = nvl(p_wip_entity_id,wdj.wip_entity_id)
380: AND wdj.wip_entity_id = es.wip_entity_id
381: )

Line 879: FROM wip_discrete_jobs

875: organization_id
876: INTO l_asset_group_id,
877: l_asset_number,
878: l_organization_id
879: FROM wip_discrete_jobs
880: WHERE wip_entity_id = p_wip_entity_id_tab(l_index);
881:
882: l_stmt_num := 110;
883:

Line 1334: wip_discrete_jobs wdj

1330: NVL(cpic.overhead_cost,0))), l_ext_precision) overhead_cost
1331: FROM wip_requirement_operations wro,
1332: cst_pac_item_costs cpic,
1333: mtl_system_items_b msi,
1334: wip_discrete_jobs wdj
1335: WHERE wro.wip_entity_id = p_wip_entity_id
1336: AND wdj.wip_entity_id = wro.wip_entity_id
1337: AND cpic.inventory_item_id = wro.inventory_item_id
1338: AND cpic.cost_group_id = p_cost_group_id

Line 1532: from wip_discrete_jobs

1528: resource_account,
1529: outside_processing_account,
1530: overhead_account,
1531: class_code wip_acct_class
1532: from wip_discrete_jobs
1533: where wip_entity_id = p_wip_entity_id;
1534:
1535: BEGIN
1536:

Line 1587: FROM wip_discrete_jobs wdj

1583: SELECT start_quantity,
1584: scheduled_completion_date
1585: INTO l_lot_size,
1586: l_scheduled_completion_date
1587: FROM wip_discrete_jobs wdj
1588: WHERE wdj.wip_entity_id = p_wip_entity_id;
1589:
1590: l_stmt_num := 210;
1591:

Line 3198: WIP_DISCRETE_JOBS. eAM enhancements project - R12 */

3194:
3195: END IF; -- end checking job balance row
3196:
3197: /* Obtain Maintenance_Object_id and Maintenance_Object_Type from
3198: WIP_DISCRETE_JOBS. eAM enhancements project - R12 */
3199: select maintenance_object_id, maintenance_object_type
3200: into l_maint_obj_id, l_maint_obj_type
3201: from wip_discrete_jobs
3202: where wip_entity_id = p_wip_entity_id

Line 3201: from wip_discrete_jobs

3197: /* Obtain Maintenance_Object_id and Maintenance_Object_Type from
3198: WIP_DISCRETE_JOBS. eAM enhancements project - R12 */
3199: select maintenance_object_id, maintenance_object_type
3200: into l_maint_obj_id, l_maint_obj_type
3201: from wip_discrete_jobs
3202: where wip_entity_id = p_wip_entity_id
3203: and organization_id = p_organization_id;
3204:
3205: /*------------------------------------------------------------