APPS.OPI_DBI_RES_PKG dependencies on OPI_DBI_JOBS_F

Line 1825: FROM opi_dbi_jobs_f job,

1821: job.conversion_rate,
1822: job.sec_conversion_rate,
1823: job.job_type,
1824: job.source
1825: FROM opi_dbi_jobs_f job,
1826: mtl_system_items_b msi,
1827: gme_material_details bmatl
1828: WHERE job.job_type = 4
1829: AND job.std_res_flag = 1

Line 1851: FROM opi_dbi_jobs_f job,

1847: bres.plan_rsrc_usage * bresuom.std_factor / hruom.std_factor plan_rsrc_usage_g,
1848: pol.cost_type_id,
1849: cmm.default_lot_cost_type_id,
1850: pol.legal_entity_id
1851: FROM opi_dbi_jobs_f job,
1852: gme_batch_header bhdr,
1853: gme_batch_steps bstep,
1854: gme_batch_step_resources bres,
1855: cr_rsrc_dtl resdtl,

Line 1963: FROM opi_dbi_jobs_f

1959: DELETE opi_dbi_res_std_f std
1960: WHERE (job_id, job_type)
1961: IN (SELECT job_id,
1962: job_type
1963: FROM opi_dbi_jobs_f
1964: WHERE std_res_flag = 1
1965: AND job_type = 4); -- need to extract again
1966:
1967: INSERT INTO opi_dbi_res_std_f

Line 2048: opi_dbi_jobs_f job,

2044: job.sec_conversion_rate,
2045: job.job_type,
2046: job.source
2047: FROM
2048: opi_dbi_jobs_f job,
2049: mtl_system_items_b msi,
2050: gme_material_details bmatl
2051: WHERE
2052: job.job_type = 4

Line 2076: opi_dbi_jobs_f job,

2072: pol.cost_type_id,
2073: cmm.default_lot_cost_type_id,
2074: pol.legal_entity_id
2075: FROM
2076: opi_dbi_jobs_f job,
2077: gme_batch_header bhdr,
2078: gme_batch_steps bstep,
2079: gme_batch_step_resources bres,
2080: cr_rsrc_dtl resdtl,

Line 2741: FROM opi_dbi_jobs_f

2737: DELETE opi_dbi_res_std_f std
2738: WHERE (job_id, job_type)
2739: IN (SELECT job_id,
2740: job_type
2741: FROM opi_dbi_jobs_f
2742: WHERE std_res_flag = 1 -- need to extract again
2743: AND source = OPI_SOURCE);
2744:
2745: INSERT INTO opi_dbi_res_std_f (

Line 2809: opi_dbi_jobs_f job,

2805: g_program_application_id,
2806: g_request_id
2807: FROM wip_operation_resources wor,
2808: wip_operations wo,
2809: opi_dbi_jobs_f job,
2810: bom_resources br,
2811: mtl_parameters mp,
2812: mtl_uom_conversions m,
2813: mtl_uom_conversions m2,

Line 2994: UPDATE opi_dbi_jobs_f

2990: --}
2991: END IF;
2992:
2993: -- update Job master's flag, for source 2
2994: UPDATE opi_dbi_jobs_f
2995: SET std_res_flag = 0,
2996: last_update_date = sysdate,
2997: last_updated_by = g_user_id,
2998: last_update_login = g_login_id

Line 3704: opi_dbi_jobs_f job,

3700: g_program_application_id,
3701: g_request_id
3702: FROM wip_operation_resources wor,
3703: wip_operations wo,
3704: opi_dbi_jobs_f job,
3705: bom_resources br,
3706: mtl_parameters mp,
3707: mtl_uom_conversions m,
3708: mtl_uom_conversions m2,

Line 3761: UPDATE opi_dbi_jobs_f

3757: retcode => retcode,
3758: p_degree => p_degree);
3759:
3760: -- Update std_res_flag in Job Master to 0 where std_res_flag = 1
3761: UPDATE opi_dbi_jobs_f
3762: SET std_res_flag = 0,
3763: last_update_date = sysdate,
3764: last_updated_by = g_user_id,
3765: last_update_login = g_login_id