APPS.OPI_DBI_COGS_PKG dependencies on OPI_DBI_CONC_PROG_RUN_LOG

Line 293: FROM opi_dbi_conc_prog_run_log log,

289: mmt.transaction_date,
290: OPI_SOURCE,
291: decode(p_lines.source_type_code, 'EXTERNAL', 2, 1 ),
292: decode(p_lines.order_source_id,10,1,0)
293: FROM opi_dbi_conc_prog_run_log log,
294: mtl_material_transactions mmt,
295: mtl_transaction_accounts mta,
296: oe_order_lines_all lines, -- child line
297: oe_order_lines_all p_lines, -- parent line

Line 338: FROM opi_dbi_conc_prog_run_log log,

334: mmt.transaction_date,
335: OPI_SOURCE,
336: 1,
337: 0
338: FROM opi_dbi_conc_prog_run_log log,
339: mtl_material_transactions mmt,
340: mtl_transaction_accounts mta,
341: oe_order_lines_all lines, -- child line
342: oe_order_lines_all l_lines, -- linking line

Line 383: FROM opi_dbi_conc_prog_run_log log,

379: mmt.transaction_date,
380: OPI_SOURCE,
381: decode(p_mmt.transaction_type_id, 33, 1, 2),
382: 0
383: FROM opi_dbi_conc_prog_run_log log,
384: mtl_material_transactions mmt,
385: mtl_material_transactions p_mmt,
386: mtl_transaction_accounts mta,
387: oe_order_lines_all lines,

Line 486: FROM opi_dbi_conc_prog_run_log log,

482: mmt.transaction_date,
483: OPI_SOURCE,
484: decode(p_lines.source_type_code, 'EXTERNAL', 2, 1 ),
485: decode(p_lines.order_source_id,10,1,0)
486: FROM opi_dbi_conc_prog_run_log log,
487: mtl_material_transactions mmt,
488: mtl_transaction_accounts mta,
489: oe_order_lines_all lines, -- child line
490: oe_order_lines_all p_lines, -- parent line

Line 527: FROM opi_dbi_conc_prog_run_log log,

523: mmt.transaction_date,
524: OPI_SOURCE,
525: 1,
526: 0
527: FROM opi_dbi_conc_prog_run_log log,
528: mtl_material_transactions mmt,
529: mtl_transaction_accounts mta,
530: oe_order_lines_all lines, -- child line
531: oe_order_lines_all l_lines, -- linking line

Line 569: FROM opi_dbi_conc_prog_run_log log,

565: mmt.transaction_date,
566: OPI_SOURCE,
567: decode(p_mmt.transaction_type_id, 33, 1, 2),
568: 0
569: FROM opi_dbi_conc_prog_run_log log,
570: mtl_material_transactions mmt,
571: mtl_material_transactions p_mmt,
572: mtl_transaction_accounts mta,
573: oe_order_lines_all lines,

Line 864: l_r12_mgr_date opi_dbi_conc_prog_run_log.last_run_date%type;

860: retcode IN OUT NOCOPY VARCHAR2) IS
861:
862: -- Declaration block
863:
864: l_r12_mgr_date opi_dbi_conc_prog_run_log.last_run_date%type;
865: l_from_bound_date opi_dbi_conc_prog_run_log.from_bound_date%type;
866: l_to_bound_date opi_dbi_conc_prog_run_log.to_bound_date%type;
867:
868: no_bounds_found exception;

Line 865: l_from_bound_date opi_dbi_conc_prog_run_log.from_bound_date%type;

861:
862: -- Declaration block
863:
864: l_r12_mgr_date opi_dbi_conc_prog_run_log.last_run_date%type;
865: l_from_bound_date opi_dbi_conc_prog_run_log.from_bound_date%type;
866: l_to_bound_date opi_dbi_conc_prog_run_log.to_bound_date%type;
867:
868: no_bounds_found exception;
869: BEGIN

Line 866: l_to_bound_date opi_dbi_conc_prog_run_log.to_bound_date%type;

862: -- Declaration block
863:
864: l_r12_mgr_date opi_dbi_conc_prog_run_log.last_run_date%type;
865: l_from_bound_date opi_dbi_conc_prog_run_log.from_bound_date%type;
866: l_to_bound_date opi_dbi_conc_prog_run_log.to_bound_date%type;
867:
868: no_bounds_found exception;
869: BEGIN
870:

Line 883: FROM opi_dbi_conc_prog_run_log

879:
880: BEGIN
881: SELECT last_run_date
882: INTO l_r12_mgr_date
883: FROM opi_dbi_conc_prog_run_log
884: WHERE etl_type = 'R12_MIGRATION';
885: EXCEPTION
886: WHEN NO_DATA_FOUND THEN
887: --{

Line 905: FROM opi_dbi_conc_prog_run_log

901:
902: BEGIN
903: SELECT from_bound_date, to_bound_date
904: INTO l_from_bound_date, l_to_bound_date
905: FROM opi_dbi_conc_prog_run_log
906: WHERE etl_type = 'COGS'
907: AND driving_table_code = 'GTV'
908: AND load_type = 'INIT';
909: EXCEPTION

Line 1260: l_from_bound_date opi_dbi_conc_prog_run_log.from_bound_date%type;

1256:
1257: PROCEDURE incremental_load_opm_cogs(errbuf IN OUT NOCOPY VARCHAR2,
1258: retcode IN OUT NOCOPY VARCHAR2) IS
1259:
1260: l_from_bound_date opi_dbi_conc_prog_run_log.from_bound_date%type;
1261: l_to_bound_date opi_dbi_conc_prog_run_log.to_bound_date%type;
1262:
1263: no_bounds_found exception;
1264:

Line 1261: l_to_bound_date opi_dbi_conc_prog_run_log.to_bound_date%type;

1257: PROCEDURE incremental_load_opm_cogs(errbuf IN OUT NOCOPY VARCHAR2,
1258: retcode IN OUT NOCOPY VARCHAR2) IS
1259:
1260: l_from_bound_date opi_dbi_conc_prog_run_log.from_bound_date%type;
1261: l_to_bound_date opi_dbi_conc_prog_run_log.to_bound_date%type;
1262:
1263: no_bounds_found exception;
1264:
1265: BEGIN

Line 1278: FROM opi_dbi_conc_prog_run_log

1274:
1275: BEGIN
1276: SELECT from_bound_date, to_bound_date
1277: INTO l_from_bound_date, l_to_bound_date
1278: FROM opi_dbi_conc_prog_run_log
1279: WHERE etl_type = 'COGS'
1280: AND driving_table_code = 'GTV'
1281: AND load_type = 'INCR';
1282: