eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on JMF_SHIKYU_CUR_RPT_TEMP

Line 126: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;

122: ,p_currency_cnv_date IN VARCHAR2
123: ,p_function_currency IN VARCHAR2
124: ,p_rate_not_found OUT NOCOPY VARCHAR2
125: ) IS
126: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
127: l_currency_cnv_date DATE;
128: l_api_name CONSTANT VARCHAR2(30) := 'cuar_get_cost_data';
129:
130:

Line 144: DELETE FROM jmf_shikyu_cur_rpt_temp;

140: END IF;
141:
142: l_func_currency_code :=p_function_currency ;
143:
144: DELETE FROM jmf_shikyu_cur_rpt_temp;
145: COMMIT;
146:
147: /* the input date format depends on server's setting.
148: To avoid the potential issues,use function which is not using mask.

Line 351: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;

347: ,haotl.NAME)
348: AND haotl.NAME <= nvl(lp_inv_org_name_to
349: ,haotl.NAME);
350:
351: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
352: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
353: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
354: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;

Line 352: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;

348: AND haotl.NAME <= nvl(lp_inv_org_name_to
349: ,haotl.NAME);
350:
351: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
352: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
353: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
354: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;

Line 353: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;

349: ,haotl.NAME);
350:
351: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
352: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
353: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
354: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;

Line 354: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;

350:
351: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
352: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
353: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
354: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;

Line 355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;

351: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
352: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
353: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
354: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;

Line 356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;

352: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
353: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
354: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;

Line 357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;

353: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
354: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;

Line 358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;

354: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;

Line 359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;

355: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;

Line 360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;

356: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;

Line 361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;

357: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;

Line 362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;

358: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;

Line 363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;

359: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
367: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;

Line 364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;

360: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
367: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
368: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;

Line 365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;

361: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
367: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
368: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
369: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;

Line 366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;

362: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
367: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
368: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
369: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
370: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;

Line 367: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;

363: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
367: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
368: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
369: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
370: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
371: l_message varchar2(200);

Line 368: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;

364: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
367: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
368: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
369: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
370: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
371: l_message varchar2(200);
372: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;--Added to display release number(When unreceived then mean release_num)

Line 369: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;

365: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
367: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
368: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
369: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
370: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
371: l_message varchar2(200);
372: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;--Added to display release number(When unreceived then mean release_num)
373:

Line 370: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;

366: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
367: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
368: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
369: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
370: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
371: l_message varchar2(200);
372: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;--Added to display release number(When unreceived then mean release_num)
373:
374: BEGIN

Line 372: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;--Added to display release number(When unreceived then mean release_num)

368: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
369: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
370: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
371: l_message varchar2(200);
372: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;--Added to display release number(When unreceived then mean release_num)
373:
374: BEGIN
375:
376: -- g_debug_level := fnd_log.g_current_runtime_level;

Line 481: INSERT INTO jmf_shikyu_cur_rpt_temp

477:
478: ELSIF (l_quantity <> 0) AND (l_unit_cost_frozen <> l_unit_cost_plan ) THEN
479:
480:
481: INSERT INTO jmf_shikyu_cur_rpt_temp
482: (SOURCE
483: ,inventory_org_name
484: ,project_num
485: ,task_num

Line 664: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;

660: AND nvl(JMF_SHIKYU_GRP. GET_SUBCONTRACTING_TYPE(repo.oem_organization_id, repo.tp_organization_id),
661: NULL) = 'C' ;
662:
663:
664: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
665: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
666: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
667: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;

Line 665: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;

661: NULL) = 'C' ;
662:
663:
664: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
665: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
666: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
667: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;

Line 666: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;

662:
663:
664: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
665: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
666: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
667: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;

Line 667: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;

663:
664: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
665: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
666: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
667: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;

Line 668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;

664: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
665: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
666: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
667: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;

Line 669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;

665: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
666: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
667: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;

Line 670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;

666: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
667: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;

Line 671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;

667: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;

Line 672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;

668: l_vendor_name jmf_shikyu_cur_rpt_temp.vendor_name%TYPE;
669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;

Line 673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;

669: l_vendor_site_code jmf_shikyu_cur_rpt_temp.vendor_site_code%TYPE;
670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;

Line 674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;

670: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;

Line 675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;

671: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;

Line 676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;

672: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;

Line 677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;

673: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
681: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;

Line 678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;

674: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
681: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
682: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;

Line 679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;

675: l_unit_price jmf_shikyu_cur_rpt_temp.unit_price%TYPE;
676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
681: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
682: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
683: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;

Line 680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;

676: l_currency jmf_shikyu_cur_rpt_temp.currency%TYPE;
677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
681: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
682: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
683: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
684: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;

Line 681: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;

677: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
681: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
682: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
683: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
684: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;
685: l_message varchar2(200);

Line 682: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;

678: l_uom_code jmf_shikyu_cur_rpt_temp.uom_code%TYPE;
679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
681: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
682: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
683: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
684: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;
685: l_message varchar2(200);
686:

Line 683: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;

679: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
681: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
682: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
683: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
684: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;
685: l_message varchar2(200);
686:
687: BEGIN

Line 684: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;

680: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
681: l_func_unit_price jmf_shikyu_cur_rpt_temp.func_unit_price%TYPE;
682: l_qty_rate jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
683: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
684: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;
685: l_message varchar2(200);
686:
687: BEGIN
688: --g_debug_level := fnd_log.g_current_runtime_level;

Line 795: INSERT INTO jmf_shikyu_cur_rpt_temp

791:
792:
793: ELSIF (l_quantity <> 0) AND (l_unit_cost_frozen <> l_unit_cost_plan ) THEN
794:
795: INSERT INTO jmf_shikyu_cur_rpt_temp
796: (SOURCE
797: ,inventory_org_name
798: ,project_num
799: ,task_num

Line 938: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;

934: AND nvl(JMF_SHIKYU_GRP. GET_SUBCONTRACTING_TYPE(oel.ship_from_org_id, oel.ship_to_org_id),
935: NULL) = 'C' ;
936:
937:
938: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
939: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
940: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
941: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;

Line 939: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;

935: NULL) = 'C' ;
936:
937:
938: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
939: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
940: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
941: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;

Line 940: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;

936:
937:
938: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
939: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
940: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
941: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;

Line 941: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;

937:
938: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
939: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
940: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
941: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;

Line 942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;

938: l_source jmf_shikyu_cur_rpt_temp.SOURCE%TYPE;
939: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
940: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
941: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;

Line 943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;

939: l_inventory_org_name jmf_shikyu_cur_rpt_temp.inventory_org_name%TYPE;
940: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
941: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;

Line 944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;

940: l_project_num jmf_shikyu_cur_rpt_temp.project_num%TYPE;
941: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;

Line 945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;

941: l_task_num jmf_shikyu_cur_rpt_temp.task_num%TYPE;
942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;
949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;

Line 946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;

942: l_order_num jmf_shikyu_cur_rpt_temp.order_num%TYPE;
943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;
949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
950: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;

Line 947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;

943: l_line_num jmf_shikyu_cur_rpt_temp.line_num%TYPE;
944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;
949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
950: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
951: l_primary_qty jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;

Line 949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;

945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;
949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
950: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
951: l_primary_qty jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
952: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
953: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;

Line 950: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;

946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;
949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
950: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
951: l_primary_qty jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
952: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
953: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;
954: l_no_ori_so_flag VARCHAR2(5);

Line 951: l_primary_qty jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;

947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;
949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
950: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
951: l_primary_qty jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
952: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
953: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;
954: l_no_ori_so_flag VARCHAR2(5);
955: l_no_appropriate_so_flag VARCHAR2(5);

Line 952: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;

948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;
949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
950: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
951: l_primary_qty jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
952: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
953: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;
954: l_no_ori_so_flag VARCHAR2(5);
955: l_no_appropriate_so_flag VARCHAR2(5);
956: l_rma_over_shipped_flag VARCHAR2(5);

Line 953: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;

949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
950: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
951: l_primary_qty jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
952: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;
953: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;
954: l_no_ori_so_flag VARCHAR2(5);
955: l_no_appropriate_so_flag VARCHAR2(5);
956: l_rma_over_shipped_flag VARCHAR2(5);
957: l_rma_qty NUMBER;

Line 1200: INSERT INTO jmf_shikyu_cur_rpt_temp

1196: l_order_line_id := l_reference_line_id;
1197:
1198: IF (l_cur_rcv_shipped_quantity <> 0) AND (l_unit_cost_frozen <> l_unit_cost_plan ) THEN
1199:
1200: INSERT INTO jmf_shikyu_cur_rpt_temp
1201: (SOURCE
1202: ,inventory_org_name
1203: ,project_num
1204: ,task_num