APPS.OPI_DBI_RES_OPM_PKG dependencies on OPI_DBI_JOBS_F

Line 481: opi_dbi_jobs_f job,

477: job.conversion_rate,
478: job.job_type,
479: job.source
480: FROM
481: opi_dbi_jobs_f job,
482: mtl_system_items_b msi,
483: ic_item_mst_b i,
484: gme_material_details bmatl
485: WHERE

Line 509: opi_dbi_jobs_f job,

505: bres.plan_rsrc_usage * bresuom.std_factor / ruom.std_factor plan_rsrc_usage,
506: bres.plan_rsrc_usage * bresuom.std_factor / hruom.std_factor plan_rsrc_usage_g,
507: pol.gl_cost_mthd
508: FROM
509: opi_dbi_jobs_f job,
510: gme_batch_header bhdr,
511: gme_batch_steps bstep,
512: gme_batch_step_resources bres,
513: cr_rsrc_dtl resdtl,

Line 578: UPDATE opi_dbi_jobs_f SET std_res_flag = 0,

574:
575: l_rowcount := SQL%ROWCOUNT;
576:
577: -- update JOb master's flag, for source 2
578: UPDATE opi_dbi_jobs_f SET std_res_flag = 0,
579: creation_date = sysdate,
580: last_update_date = sysdate,
581: created_by = g_user_id,
582: last_updated_by = g_user_id,

Line 948: FROM opi_dbi_jobs_f

944:
945: DELETE opi_dbi_res_std_f std
946: WHERE (job_id, job_type)
947: IN ( SELECT job_id, job_type
948: FROM opi_dbi_jobs_f
949: WHERE std_res_flag = 1
950: AND job_type = 4 -- need to extract again
951: );
952:

Line 1019: opi_dbi_jobs_f job,

1015: job.conversion_rate,
1016: job.job_type,
1017: job.source
1018: FROM
1019: opi_dbi_jobs_f job,
1020: mtl_system_items_b msi,
1021: ic_item_mst_b i,
1022: gme_material_details bmatl
1023: WHERE

Line 1047: opi_dbi_jobs_f job,

1043: bres.plan_rsrc_usage * bresuom.std_factor / ruom.std_factor plan_rsrc_usage,
1044: bres.plan_rsrc_usage * bresuom.std_factor / hruom.std_factor plan_rsrc_usage_g,
1045: pol.gl_cost_mthd
1046: FROM
1047: opi_dbi_jobs_f job,
1048: gme_batch_header bhdr,
1049: gme_batch_steps bstep,
1050: gme_batch_step_resources bres,
1051: cr_rsrc_dtl resdtl,

Line 1116: UPDATE opi_dbi_jobs_f SET std_res_flag = 0,

1112:
1113: l_rowcount := SQL%ROWCOUNT;
1114:
1115: -- update JOb master's flag, for source 2
1116: UPDATE opi_dbi_jobs_f SET std_res_flag = 0,
1117: creation_date = sysdate,
1118: last_update_date = sysdate,
1119: created_by = g_user_id,
1120: last_updated_by = g_user_id,