[Home] [Help]
1077: END IF;
1078: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;
1079:
1080: /* GTV is summarised and joined with MMT Staging. GTV gives the transaction value while
1081: MMT Staging gives the quantity. Join with GME_MATERIAL_DETAILS is required to get the
1082: cost alloc factor for products. */
1083: l_stmt_num := 20;
1084: INSERT
1085: INTO OPI_DBI_JOBS_TXN_STG
1201: gtv.line_type,
1202: gtv.transaction_date,
1203: gtv.accounted_flag
1204: ) GTV,
1205: GME_MATERIAL_DETAILS MTL_DTL,
1206: OPI_DBI_JOBS_TXN_MMT_STG MMT_STG,
1207: mtl_system_items_b msi
1208: where
1209: GTV.organization_id = MTL_DTL.organization_id and
1298: END IF;
1299: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;
1300:
1301: /* GTV is summarised and joined with MMT. GTV gives the transaction value while
1302: MMT gives the quantity. Join with GME_MATERIAL_DETAILS is required to get the
1303: cost alloc factor for products. */
1304: l_stmt_num := 20;
1305: INSERT
1306: INTO OPI_DBI_JOBS_TXN_STG
1422: gtv.line_type,
1423: gtv.transaction_date,
1424: gtv.accounted_flag
1425: ) GTV,
1426: GME_MATERIAL_DETAILS MTL_DTL,
1427: MTL_MATERIAL_TRANSACTIONS MMT_STG,
1428: mtl_system_items_b msi
1429: where
1430: GTV.organization_id = MTL_DTL.organization_id and
1546: s_program_application_id,
1547: s_request_id
1548: from
1549: OPI_DBI_OPM_SCALED_MTL scaled,
1550: gme_material_details coprod,
1551: gl_subr_led led,
1552: (
1553: SELECT
1554: jobs.Organization_id,
1707: sub.doc_id,
1708: sub.line_id,
1709: TRUNC(sub.gl_trans_date)
1710: ) led,
1711: GME_MATERIAL_DETAILS mtl_dtl,
1712: mtl_system_items_b msi
1713: WHERE
1714: itp.doc_type = led.doc_type AND
1715: itp.doc_id = led.doc_id AND
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
2923: jobs.status = 'Closed' and
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'
2962: and dtl.line_type in (-1,2)
3168: jobs.assembly_item_id,
3169: mtl_dtl.cost_alloc cost_alloc
3170: from
3171: opi_dbi_jobs_stg jobs,
3172: gme_material_details mtl_dtl
3173: where
3174: jobs.source in (2,3) and
3175: jobs.job_type = 4 and
3176: jobs.status = 'Closed' and
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'
3215: and dtl.line_type in (-1,2)