APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on OPI_DBI_JOBS_F

Line 448: OPI_DBI_JOBS_F jobs

444: jobs.COMPLETION_DATE TRANS_DATE
445: from
446: OPI_DBI_OPM_SCALED_MTL scaled,
447: ic_whse_mst whse,
448: OPI_DBI_JOBS_F jobs
449: where
450: whse.mtl_organization_id = jobs.organization_id
451: and jobs.job_id = scaled.batch_id
452: and jobs.job_type = 4

Line 470: OPI_DBI_JOBS_F jobs,

466: update /*+ parallel(f) */ OPI_DBI_JOB_MTL_DETAILS_F f
467: set STANDARD_VALUE_B =
468: (select f.standard_quantity * costs.total_cost
469: from opi_pmi_cost_result_gtmp costs,
470: OPI_DBI_JOBS_F jobs,
471: ic_whse_mst whse,
472: ic_item_mst_b item,
473: mtl_System_items_b msi
474: where whse.mtl_organization_id = f.organization_id

Line 593: OPI_DBI_JOBS_F rates,

589: led.uom_code uom_code,
590: rates.conversion_rate conversion_rate,
591: rates.sec_conversion_rate sec_conversion_rate
592: FROM
593: OPI_DBI_JOBS_F rates,
594: (
595: SELECT
596: jobs.Organization_id,
597: jobs.Job_Id,

Line 634: OPI_DBI_JOBS_F jobs,

630: jobs.UOM_Code,
631: gmd.line_type,
632: gmd.material_detail_id line_id
633: from
634: OPI_DBI_JOBS_F jobs,
635: GME_MATERIAL_DETAILS gmd
636: where
637: jobs.job_id = gmd.batch_id and
638: jobs.status = 'Closed' and

Line 652: OPI_DBI_JOBS_F jobs,

648: jobs.UOM_Code,
649: 0,
650: gbsr.batchstep_resource_id line_id
651: from
652: OPI_DBI_JOBS_F jobs,
653: GME_BATCH_STEP_RESOURCES gbsr
654: where
655: jobs.job_id = gbsr.batch_id and
656: jobs.status = 'Closed' and

Line 857: OPI_DBI_JOBS_F jobs,

853: g_program_login_id PROGRAM_LOGIN_ID,
854: g_program_application_id PROGRAM_APPLICATION_ID,
855: g_request_id REQUEST_ID
856: FROM
857: OPI_DBI_JOBS_F jobs,
858: WIP_PERIOD_BALANCES wpb
859: WHERE jobs.Status = 'Closed'
860: AND jobs.organization_id = wpb.organization_id
861: AND jobs.job_id = decode (wpb.class_type,

Line 938: OPI_DBI_JOBS_F jobs,

934: jobs.organization_id,
935: jobs.conversion_rate,
936: jobs.sec_conversion_rate
937: from
938: OPI_DBI_JOBS_F jobs,
939: GME_MATERIAL_DETAILS mtl_dtl
940: where
941: jobs.job_id = mtl_dtl.batch_id and
942: jobs.organization_id = mtl_dtl.organization_id and

Line 962: OPI_DBI_JOBS_F jobs,

958: jobs.Organization_id,
959: jobs.conversion_rate,
960: jobs.sec_conversion_rate
961: from
962: OPI_DBI_JOBS_F jobs,
963: GME_BATCH_STEP_RESOURCES gbsr
964: where
965: jobs.job_id = gbsr.batch_id and
966: jobs.source = 2 and

Line 1196: , OPI_DBI_JOBS_F rates

1192: WHERE jobs.Status = 'Closed'
1193: AND jobs.ORGANIZATION_ID = wpb.ORGANIZATION_ID
1194: AND wpb.CLASS_TYPE = 2
1195: AND jobs.Job_id = wpb.REPETITIVE_SCHEDULE_ID) jobs
1196: , OPI_DBI_JOBS_F rates
1197: WHERE 1=1
1198: AND jobs.ORGANIZATION_ID = rates.organization_id
1199: AND jobs.job_id = rates.job_id
1200: AND jobs.job_type = rates.job_type

Line 1403: OPI_DBI_JOBS_F rates

1399: jobs.assembly_item_id,
1400: jobs.actual_qty_completed,
1401: jobs.uom_code,
1402: jobs.completion_date) var,
1403: OPI_DBI_JOBS_F rates
1404: where
1405: var.organization_id = rates.organization_id and
1406: var.job_id = rates.job_id and
1407: var.job_type = rates.job_type and

Line 1803: OPI_DBI_JOBS_F jobs,

1799: jobs.actual_qty_completed,
1800: mtl_dtl.line_type line_type,
1801: jobs.Organization_id
1802: from
1803: OPI_DBI_JOBS_F jobs,
1804: GME_MATERIAL_DETAILS mtl_dtl
1805: where
1806: jobs.source = 2 and
1807: jobs.line_type = 1 and

Line 1825: OPI_DBI_JOBS_F jobs,

1821: jobs.actual_qty_completed,
1822: -1 line_type,
1823: jobs.Organization_id
1824: from
1825: OPI_DBI_JOBS_F jobs,
1826: GME_BATCH_STEP_RESOURCES gbsr
1827: where
1828: jobs.source = 2 and
1829: jobs.line_type = 1 and