[Home] [Help]
1561: itp.line_id,
1562: itp.trans_date,
1563: itp.line_type
1564: FROM
1565: OPI_DBI_JOBS_F jobs,
1566: IC_TRAN_PND itp
1567: WHERE
1568: jobs.source = 3 AND
1569: itp.completed_ind = 1 AND
2118: WHERE
2119: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2120: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2121: WE.ENTITY_TYPE in (1,3,5,8) AND
2122: WE.WIP_ENTITY_ID in (SELECT JOB_ID FROM OPI_DBI_JOBS_F WHERE Std_Req_Flag=1 AND JOB_TYPE in (1,5))
2123: GROUP BY
2124: WRO.ORGANIZATION_ID,
2125: WRO.INVENTORY_ITEM_ID,
2126: WRO.WIP_ENTITY_ID,
2138: WHERE
2139: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2140: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2141: WE.ENTITY_TYPE = 2 AND
2142: WRO.REPETITIVE_SCHEDULE_ID in (SELECT JOB_ID FROM OPI_DBI_JOBS_F WHERE Std_Req_Flag=1 AND JOB_TYPE=2)
2143: GROUP BY
2144: WRO.ORGANIZATION_ID,
2145: WRO.INVENTORY_ITEM_ID,
2146: WRO.REPETITIVE_SCHEDULE_ID
2184: decode (sign(wfs.scheduled_completion_date - nvl(wfs.date_closed,wfs.scheduled_completion_date)),1,wfs.date_closed,wfs.scheduled_completion_date) < nvl(bom_join.disable_date, sysdate) and
2185: wfs.organization_id = bom_join.organization_id and
2186: wfs.PRIMARY_ITEM_ID = bom_join.assembly_item_id and
2187: nvl(wfs.alternate_bom_designator,1) = nvl(bom_join.alternate_bom_designator,1) and
2188: WFS.WIP_ENTITY_ID in (SELECT JOB_ID FROM OPI_DBI_JOBS_F WHERE Std_Req_Flag=1 AND
2189: JOB_TYPE=3)
2190: GROUP BY
2191: wfs.organization_id,
2192: bom_join.component_item_id,
2345: WHERE
2346: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2347: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2348: WE.ENTITY_TYPE in (1,3,5,8) AND
2349: WE.WIP_ENTITY_ID in (SELECT JOB_ID FROM OPI_DBI_JOBS_F WHERE Std_Req_Flag=1 AND JOB_TYPE in (1,5))
2350: GROUP BY
2351: WRO.ORGANIZATION_ID,
2352: WRO.INVENTORY_ITEM_ID,
2353: WRO.WIP_ENTITY_ID,
2365: WHERE
2366: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2367: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2368: WE.ENTITY_TYPE = 2 AND
2369: WRO.REPETITIVE_SCHEDULE_ID in (SELECT JOB_ID FROM OPI_DBI_JOBS_F WHERE Std_Req_Flag=1 AND JOB_TYPE=2)
2370: GROUP BY
2371: WRO.ORGANIZATION_ID,
2372: WRO.INVENTORY_ITEM_ID,
2373: WRO.REPETITIVE_SCHEDULE_ID
2408: decode (sign(wfs.scheduled_completion_date - nvl(wfs.date_closed,wfs.scheduled_completion_date)),1,wfs.date_closed,wfs.scheduled_completion_date) < nvl(t.disable_date, sysdate) and
2409: wfs.organization_id = t.organization_id and
2410: wfs.PRIMARY_ITEM_ID = t.assembly_item_id and
2411: nvl(wfs.alternate_bom_designator,1) = nvl(t.alternate_bom_designator,1) and
2412: WFS.WIP_ENTITY_ID in (SELECT JOB_ID FROM OPI_DBI_JOBS_F WHERE Std_Req_Flag=1 AND
2413: JOB_TYPE=3)
2414: GROUP BY
2415: wfs.organization_id,
2416: t.component_item_id,
2914: jobs.organization_id organization_id,
2915: jobs.assembly_item_id,
2916: mtl_dtl.cost_alloc cost_alloc
2917: from
2918: opi_dbi_jobs_f jobs,
2919: gme_material_details mtl_dtl
2920: where
2921: jobs.source in (2,3) and
2922: jobs.job_type = 4 and
2953: dtl.inventory_item_id ,
2954: dtl.plan_qty,
2955: cost_alloc_in
2956: from
2957: OPI_DBI_JOBS_F job,
2958: gme_material_details dtl
2959: where
2960: job.job_id = dtl.batch_id
2961: and job.status = 'Closed'
3206: dtl.inventory_item_id ,
3207: dtl.plan_qty,
3208: cost_alloc_in
3209: from
3210: OPI_DBI_JOBS_F job,
3211: gme_material_details dtl
3212: where
3213: job.job_id = dtl.batch_id
3214: and job.status = 'Closed'
4114: /* Access MMT and obtain the list of jobs that have WIP material transactions
4115: after the first uncosted transaction and use this list of jobs and update
4116: Include_Jobs in Jobs Table with 2 and leave the rest with 1 */
4117: l_stmt_num := 20;
4118: UPDATE /*+ parallel(f) */ OPI_DBI_JOBS_F f
4119: SET
4120: Include_Job = 2
4121: WHERE
4122: JOB_ID IN (
4140: l_stmt_num := 30;
4141: commit;
4142:
4143: l_stmt_num := 40;
4144: UPDATE /*+ parallel(f) */ OPI_DBI_JOBS_F f
4145: SET Std_Req_Flag = 0
4146: WHERE Std_Req_Flag = 1 AND SOURCE=1;
4147: commit;
4148: