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_CFR_PVT dependencies on JMF_SHIKYU_CFR_RPT_TEMP

Line 376: DELETE FROM JMF_SHIKYU_CFR_RPT_TEMP;

372: END IF;
373:
374: --clear old data if any
375: DELETE FROM JMF_SHIKYU_CFR_MID_TEMP;
376: DELETE FROM JMF_SHIKYU_CFR_RPT_TEMP;
377: COMMIT;
378:
379: -- Valid parameter validation;
380: -- if all parameters are valid then continue; otherwise raise an error message in log;

Line 3090: -- COMMENT : get the crude data into jmf_shikyu_cfr_rpt_temp with

3086:
3087: --========================================================================
3088: -- PROCEDURE : rpt_get_crude_data PUBLIC ,
3089: -- PARAMETERS: p_rcv_row_type row type id to identify the rcv_transaction
3090: -- COMMENT : get the crude data into jmf_shikyu_cfr_rpt_temp with
3091: -- RPT_DATA_TYPE = CFR_CRUDE_DATA
3092: -- PRE-COND :
3093: -- EXCEPTIONS:
3094: --========================================================================

Line 3119: INSERT INTO jmf_shikyu_cfr_rpt_temp

3115: ,'.begin');
3116: END IF;
3117:
3118: -- insert the onhand items that with SubContracting Order.
3119: INSERT INTO jmf_shikyu_cfr_rpt_temp
3120: (rpt_mode
3121: ,TRANSACTION_ID
3122: ,RPT_DATA_TYPE
3123: ,oem_inv_org_id

Line 3390: -- COMMENT : get the Component Estimated data into jmf_shikyu_cfr_rpt_temp with

3386:
3387: --========================================================================
3388: -- PROCEDURE : rpt_get_Comp_Estimated_data PUBLIC ,
3389: -- PARAMETERS: p_rcv_row_type row type id to identify the rcv_transaction
3390: -- COMMENT : get the Component Estimated data into jmf_shikyu_cfr_rpt_temp with
3391: -- RPT_DATA_TYPE = CFR_EXT_COMPONENT
3392: -- PRE-COND :
3393: -- EXCEPTIONS:
3394: --========================================================================

Line 3413: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

3409: ,g_module_prefix || l_api_name
3410: ,'.begin');
3411: END IF;
3412:
3413: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP
3414: (rpt_mode
3415: ,RPT_DATA_TYPE
3416: ,oem_inv_org_id
3417: ,supplier_id

Line 3457: FROM JMF_SHIKYU_CFR_RPT_TEMP temp

3453: ,temp.project_id
3454: ,temp.task_id
3455: ,temp.primary_uom shikyu_primary_uom
3456: ,SUM(temp.estimated_qty) shikyu_estimated_qty
3457: FROM JMF_SHIKYU_CFR_RPT_TEMP temp
3458: WHERE temp.rpt_DATA_TYPE = CFR_CRUDE_DATA
3459: GROUP BY temp.rpt_mode
3460: ,temp.oem_inv_org_id
3461: ,temp.supplier_id

Line 3515: FROM JMF_SHIKYU_CFR_RPT_TEMP rpt_temp

3511: --added to fix project_number related issue end
3512: ,rpt_temp.primary_uom primary_uom
3513: ,rpt_temp.estimated_qty
3514: ,rpt_temp.transaction_id transaction_id
3515: FROM JMF_SHIKYU_CFR_RPT_TEMP rpt_temp
3516: WHERE rpt_temp.rpt_DATA_TYPE = CFR_CRUDE_DATA
3517: GROUP BY rpt_temp.rpt_mode
3518: ,rpt_temp.oem_inv_org_id
3519: ,rpt_temp.supplier_id

Line 3573: /* UPDATE JMF_SHIKYU_CFR_RPT_TEMP jscrt

3569: text="--updated for fix bug 5231233 Begin"
3570: */
3571:
3572: -- Deleted Update to fix bug 5665445 for incorrect onhand Qty in Secondary UOM case
3573: /* UPDATE JMF_SHIKYU_CFR_RPT_TEMP jscrt
3574: SET jscrt.estimated_qty = PO_UOM_S.po_uom_convert_p(jscrt.primary_uom
3575: ,jscrt.uom
3576: ,jscrt.item_id) *jscrt.ESTIMATED_QTY,
3577: (SELECT jscmt.primary_unconsumed_quantity

Line 3596: UPDATE JMF_SHIKYU_CFR_RPT_TEMP temp

3592: --add for fix bug 4997302 End
3593: */
3594:
3595: -- update the SHIKYU_components item number, desc, type info
3596: UPDATE JMF_SHIKYU_CFR_RPT_TEMP temp
3597: SET temp.item_number = (SELECT msibk.concatenated_segments
3598: FROM MTL_SYSTEM_ITEMS_B_KFV msibk
3599: WHERE temp.tp_inv_org_id =
3600: msibk.organization_id

Line 3656: -- COMMENT : get the SubPO info for the component data into jmf_shikyu_cfr_rpt_temp with

3652: -- PROCEDURE : rpt_get_SubPO_data PUBLIC ,
3653: -- PARAMETERS: p_rcv_row_type row type id to identify the rcv_transaction
3654: -- p_ou_id ou_id to identify period infor
3655: -- p_days_received user entered parameter to determine period
3656: -- COMMENT : get the SubPO info for the component data into jmf_shikyu_cfr_rpt_temp with
3657: -- RPT_DATA_TYPE = CFR_EXT_SUBCONTRACT_PO
3658: -- PRE-COND :
3659: -- EXCEPTIONS:
3660: --========================================================================

Line 3679: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

3675: ,g_module_prefix || l_api_name
3676: ,'.begin');
3677: END IF;
3678:
3679: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP
3680: (RPT_MODE
3681: ,RPT_DATA_TYPE
3682: ,oem_inv_org_id
3683: ,supplier_id

Line 3834: -- COMMENT : get the SubPO info for the component data into jmf_shikyu_cfr_rpt_temp with

3830:
3831: --========================================================================
3832: -- PROCEDURE : rpt_get_UnReceived_data PUBLIC ,
3833: -- PARAMETERS: p_rcv_row_type row type id to identify the rcv_transaction
3834: -- COMMENT : get the SubPO info for the component data into jmf_shikyu_cfr_rpt_temp with
3835: -- RPT_DATA_TYPE = CFR_EXT_UN_RCV
3836: -- PRE-COND :
3837: -- EXCEPTIONS: do not consider the SO return, and RepSO with RepPO is one to one.
3838: --========================================================================

Line 3868: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

3864: ,g_module_prefix || l_api_name
3865: ,'.begin');
3866: END IF;
3867:
3868: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP
3869: (rpt_mode
3870: ,rpt_data_type
3871: ,Oem_Inv_Org_Id
3872: ,Tp_Inv_Org_Id

Line 3942: FROM JMF_SHIKYU_CFR_RPT_TEMP jscrt

3938: AND jsr.tp_organization_id = hoi.organization_id
3939: AND hoi.org_information_context = 'Customer/Supplier Association'
3940: -- Amy updated to fix bug 5583680 start
3941: /*AND (SELECT COUNT(*)
3942: FROM JMF_SHIKYU_CFR_RPT_TEMP jscrt
3943: WHERE jscrt.rpt_data_type = CFR_EXT_COMPONENT
3944: AND jscrt.oem_inv_org_id = jsr.oem_organization_id
3945: AND jscrt.tp_inv_org_id = jsr.tp_organization_id) > 0
3946: AND JMF_SHIKYU_RPT_UTIL.get_item_primary_quantity(oola.sold_from_org_id

Line 4013: -- COMMENT : get the received data in days into jmf_shikyu_cfr_rpt_temp with

4009:
4010: --========================================================================
4011: -- PROCEDURE : rpt_get_Received_data PUBLIC ,
4012: -- PARAMETERS: p_rcv_row_type row type id to identify the rcv_transaction
4013: -- COMMENT : get the received data in days into jmf_shikyu_cfr_rpt_temp with
4014: -- RPT_DATA_TYPE = CFR_EXT_RCV_IN_DAYS
4015: -- PRE-COND :
4016: -- EXCEPTIONS: do not consider the SO return, and RepSO with RepPO is one to one.
4017: --========================================================================

Line 4040: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

4036: ,'.begin');
4037: END IF;
4038:
4039: -- data that Shipped = received and exptected rcv date is in p_days_received
4040: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP
4041: (rpt_mode
4042: ,rpt_data_type
4043: ,Oem_Inv_Org_Id
4044: ,Tp_Inv_Org_Id

Line 4107: FROM JMF_SHIKYU_CFR_RPT_TEMP jscrt

4103: AND plla.line_location_id = jsr.replenishment_po_shipment_id
4104: AND jsr.tp_organization_id = hoi.organization_id
4105: AND hoi.org_information_context = 'Customer/Supplier Association'
4106: AND (SELECT COUNT(*)
4107: FROM JMF_SHIKYU_CFR_RPT_TEMP jscrt
4108: WHERE jscrt.rpt_data_type = CFR_EXT_COMPONENT
4109: AND jscrt.oem_inv_org_id = jsr.oem_organization_id
4110: AND jscrt.tp_inv_org_id = jsr.tp_organization_id) > 0
4111: AND (SYSDATE - NVL(plla.need_by_date

Line 4158: -- COMMENT : get the Component data into jmf_shikyu_cfr_rpt_temp with

4154:
4155: --========================================================================
4156: -- PROCEDURE : rpt_get_Int_data PUBLIC ,
4157: -- PARAMETERS: p_rcv_row_type row type id to identify the rcv_transaction
4158: -- COMMENT : get the Component data into jmf_shikyu_cfr_rpt_temp with
4159: -- RPT_DATA_TYPE = CFR_INT_COMPONENT
4160: -- PRE-COND :
4161: -- EXCEPTIONS:
4162: --========================================================================

Line 4182: INSERT INTO jmf_shikyu_cfr_rpt_temp

4178: ,'.begin');
4179: END IF;
4180:
4181: -- get the data for internal report
4182: INSERT INTO jmf_shikyu_cfr_rpt_temp
4183: (rpt_mode
4184: ,rpt_data_type
4185: ,oem_inv_org_id
4186: ,oem_inv_org_code

Line 4250: FROM jmf_shikyu_cfr_rpt_temp jscrt

4246: ,jscrt.functional_currency Iss_functional_currency
4247: ,SUM(jscrt.value1) Iss_estimated_qty_Sum_Pri
4248: ,jscrt.value2 Iss_SHIKYU_Price_PriU
4249: ,jscrt.value3 Iss_SHIKYU_Cost_PriU
4250: FROM jmf_shikyu_cfr_rpt_temp jscrt
4251: ,HR_ALL_ORGANIZATION_UNITS haou
4252: WHERE jscrt.oem_inv_org_id = haou.organization_id
4253: AND jscrt.rpt_data_type = CFR_CRUDE_DATA
4254: GROUP BY jscrt.oem_inv_org_id

Line 4344: FROM jmf_shikyu_cfr_rpt_temp jscrt

4340: ,jscrt.value1 value1
4341: ,jscrt.value2 value2
4342: ,jscrt.value3 value3
4343: ,jscrt.transaction_id transaction_id
4344: FROM jmf_shikyu_cfr_rpt_temp jscrt
4345: ,HR_ALL_ORGANIZATION_UNITS_TL haou
4346: WHERE jscrt.oem_inv_org_id = haou.organization_id
4347: AND jscrt.rpt_data_type = CFR_CRUDE_DATA
4348: AND haou.language = USERENV('LANG')

Line 4425: /* UPDATE JMF_SHIKYU_CFR_RPT_TEMP jscrt

4421: text="--updated for fix bug 5231233 Begin Internal"
4422: */
4423:
4424: -- Deleted Update to fix bug 5665445 for incorrect onhand Qty in Secondary UOM case
4425: /* UPDATE JMF_SHIKYU_CFR_RPT_TEMP jscrt
4426: SET jscrt.estimated_qty = PO_UOM_S.po_uom_convert_p(jscrt.primary_uom
4427: ,jscrt.uom
4428: ,jscrt.item_id) *jscrt.ESTIMATED_QTY,
4429: (SELECT jscmt.primary_unconsumed_quantity

Line 4480: -- COMMENT : get the SubPO info for the component data into jmf_shikyu_cfr_rpt_temp with

4476:
4477: --========================================================================
4478: -- PROCEDURE : rpt_get_SubPO_data_Onhand PUBLIC ,
4479: -- PARAMETERS: p_rcv_row_type row type id to identify the rcv_transaction
4480: -- COMMENT : get the SubPO info for the component data into jmf_shikyu_cfr_rpt_temp with
4481: -- These subPOs can affect onhand quantity in MP inventory.
4482: -- RPT_DATA_TYPE = CFR_EXT_SUBPO_AFT_ONHAND
4483: -- PRE-COND :
4484: -- EXCEPTIONS:

Line 4504: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

4500: ,g_module_prefix || l_api_name
4501: ,'.begin');
4502: END IF;
4503:
4504: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP
4505: (RPT_MODE
4506: ,RPT_DATA_TYPE
4507: ,oem_inv_org_id
4508: ,supplier_id

Line 4551: FROM JMF_SHIKYU_CFR_RPT_TEMP temp

4547: ,msibk.concatenated_segments
4548: ,msibk.description
4549: ,wro.required_quantity
4550: ,wro.quantity_issued
4551: FROM JMF_SHIKYU_CFR_RPT_TEMP temp
4552: ,jmf_subcontract_orders jso
4553: ,wip_requirement_operations wro
4554: ,MTL_SYSTEM_ITEMS_B_KFV msibk
4555: WHERE temp.rpt_DATA_TYPE = CFR_CRUDE_DATA

Line 4743: -- PARAMETERS: p_rpt_data_type row type in jmf_shikyu_cfr_rpt_temp

4739: END rpt_debug_show_mid_data;
4740:
4741: --========================================================================
4742: -- PROCEDURE : rpt_debug_show_temp_data PUBLIC ,
4743: -- PARAMETERS: p_rpt_data_type row type in jmf_shikyu_cfr_rpt_temp
4744: -- p_output_to the parameter for debug_output
4745: -- COMMENT : show the data in temp table jmf_shikyu_cfr_rpt_temp
4746: -- using debug_output
4747: -- PRE-COND :

Line 4745: -- COMMENT : show the data in temp table jmf_shikyu_cfr_rpt_temp

4741: --========================================================================
4742: -- PROCEDURE : rpt_debug_show_temp_data PUBLIC ,
4743: -- PARAMETERS: p_rpt_data_type row type in jmf_shikyu_cfr_rpt_temp
4744: -- p_output_to the parameter for debug_output
4745: -- COMMENT : show the data in temp table jmf_shikyu_cfr_rpt_temp
4746: -- using debug_output
4747: -- PRE-COND :
4748: -- EXCEPTIONS:
4749: --========================================================================

Line 4757: CURSOR l_cur_get_temp_data(lrpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE) IS

4753: ,p_output_to IN VARCHAR2
4754: ) IS
4755: l_api_name CONSTANT VARCHAR2(30) := 'rpt_debug_show_temp_data';
4756:
4757: CURSOR l_cur_get_temp_data(lrpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE) IS
4758: SELECT rpt_mode
4759: ,rpt_data_type
4760: ,oem_inv_org_id
4761: ,oem_inv_org_code

Line 4788: FROM jmf_shikyu_cfr_rpt_temp

4784: ,functional_currency
4785: ,value1 --Qty in Primary UOM
4786: ,value2 --SHIKYU Price in Pri UOM and Pri Currency
4787: ,value3
4788: FROM jmf_shikyu_cfr_rpt_temp
4789: WHERE (lrpt_data_type IS NULL)
4790: OR (rpt_data_type = lrpt_data_type)
4791: ORDER BY rpt_mode
4792: ,rpt_data_type

Line 4797: l_rpt_mode jmf_shikyu_cfr_rpt_temp.rpt_mode%TYPE;

4793: ,oem_inv_org_id
4794: ,supplier_id
4795: ,site_id;
4796:
4797: l_rpt_mode jmf_shikyu_cfr_rpt_temp.rpt_mode%TYPE;
4798: l_rpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE;
4799: l_oem_inv_org_id jmf_shikyu_cfr_rpt_temp.oem_inv_org_id%TYPE;
4800: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;
4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;

Line 4798: l_rpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE;

4794: ,supplier_id
4795: ,site_id;
4796:
4797: l_rpt_mode jmf_shikyu_cfr_rpt_temp.rpt_mode%TYPE;
4798: l_rpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE;
4799: l_oem_inv_org_id jmf_shikyu_cfr_rpt_temp.oem_inv_org_id%TYPE;
4800: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;
4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;
4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;

Line 4799: l_oem_inv_org_id jmf_shikyu_cfr_rpt_temp.oem_inv_org_id%TYPE;

4795: ,site_id;
4796:
4797: l_rpt_mode jmf_shikyu_cfr_rpt_temp.rpt_mode%TYPE;
4798: l_rpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE;
4799: l_oem_inv_org_id jmf_shikyu_cfr_rpt_temp.oem_inv_org_id%TYPE;
4800: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;
4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;
4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;
4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;

Line 4800: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;

4796:
4797: l_rpt_mode jmf_shikyu_cfr_rpt_temp.rpt_mode%TYPE;
4798: l_rpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE;
4799: l_oem_inv_org_id jmf_shikyu_cfr_rpt_temp.oem_inv_org_id%TYPE;
4800: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;
4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;
4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;
4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;
4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;

Line 4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;

4797: l_rpt_mode jmf_shikyu_cfr_rpt_temp.rpt_mode%TYPE;
4798: l_rpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE;
4799: l_oem_inv_org_id jmf_shikyu_cfr_rpt_temp.oem_inv_org_id%TYPE;
4800: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;
4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;
4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;
4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;
4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;
4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;

Line 4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;

4798: l_rpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE;
4799: l_oem_inv_org_id jmf_shikyu_cfr_rpt_temp.oem_inv_org_id%TYPE;
4800: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;
4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;
4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;
4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;
4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;
4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;
4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;

Line 4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;

4799: l_oem_inv_org_id jmf_shikyu_cfr_rpt_temp.oem_inv_org_id%TYPE;
4800: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;
4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;
4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;
4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;
4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;
4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;
4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;
4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;

Line 4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;

4800: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;
4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;
4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;
4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;
4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;
4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;
4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;
4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;
4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;

Line 4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;

4801: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;
4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;
4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;
4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;
4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;
4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;
4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;
4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;
4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;

Line 4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;

4802: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;
4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;
4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;
4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;
4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;
4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;
4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;
4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;
4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;

Line 4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;

4803: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;
4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;
4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;
4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;
4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;
4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;
4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;
4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;
4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;

Line 4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;

4804: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;
4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;
4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;
4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;
4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;
4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;
4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;
4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;
4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;

Line 4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;

4805: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;
4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;
4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;
4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;
4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;
4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;
4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;
4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;
4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;

Line 4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;

4806: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;
4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;
4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;
4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;
4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;
4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;
4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;
4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;
4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;

Line 4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;

4807: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;
4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;
4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;
4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;
4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;
4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;
4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;
4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;
4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;

Line 4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;

4808: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;
4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;
4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;
4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;
4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;
4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;
4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;
4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;
4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;

Line 4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;

4809: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;
4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;
4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;
4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;
4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;
4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;
4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;
4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;
4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;

Line 4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;

4810: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;
4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;
4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;
4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;
4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;
4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;
4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;
4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;
4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;

Line 4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;

4811: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;
4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;
4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;
4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;
4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;
4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;
4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;
4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;
4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;

Line 4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;

4812: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;
4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;
4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;
4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;
4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;
4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;
4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;
4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;
4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;

Line 4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;

4813: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;
4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;
4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;
4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;
4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;
4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;
4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;
4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;
4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;

Line 4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;

4814: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;
4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;
4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;
4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;
4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;
4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;
4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;
4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;
4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;

Line 4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;

4815: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;
4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;
4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;
4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;
4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;
4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;
4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;
4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;
4823: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;

Line 4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;

4816: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;
4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;
4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;
4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;
4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;
4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;
4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;
4823: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;
4824: l_value1 jmf_shikyu_cfr_rpt_temp.value1%TYPE;

Line 4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;

4817: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;
4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;
4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;
4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;
4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;
4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;
4823: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;
4824: l_value1 jmf_shikyu_cfr_rpt_temp.value1%TYPE;
4825: l_value2 jmf_shikyu_cfr_rpt_temp.value2%TYPE;

Line 4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;

4818: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;
4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;
4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;
4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;
4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;
4823: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;
4824: l_value1 jmf_shikyu_cfr_rpt_temp.value1%TYPE;
4825: l_value2 jmf_shikyu_cfr_rpt_temp.value2%TYPE;
4826: l_value3 jmf_shikyu_cfr_rpt_temp.value3%TYPE;

Line 4823: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;

4819: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;
4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;
4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;
4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;
4823: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;
4824: l_value1 jmf_shikyu_cfr_rpt_temp.value1%TYPE;
4825: l_value2 jmf_shikyu_cfr_rpt_temp.value2%TYPE;
4826: l_value3 jmf_shikyu_cfr_rpt_temp.value3%TYPE;
4827:

Line 4824: l_value1 jmf_shikyu_cfr_rpt_temp.value1%TYPE;

4820: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;
4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;
4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;
4823: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;
4824: l_value1 jmf_shikyu_cfr_rpt_temp.value1%TYPE;
4825: l_value2 jmf_shikyu_cfr_rpt_temp.value2%TYPE;
4826: l_value3 jmf_shikyu_cfr_rpt_temp.value3%TYPE;
4827:
4828: BEGIN

Line 4825: l_value2 jmf_shikyu_cfr_rpt_temp.value2%TYPE;

4821: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;
4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;
4823: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;
4824: l_value1 jmf_shikyu_cfr_rpt_temp.value1%TYPE;
4825: l_value2 jmf_shikyu_cfr_rpt_temp.value2%TYPE;
4826: l_value3 jmf_shikyu_cfr_rpt_temp.value3%TYPE;
4827:
4828: BEGIN
4829: -- **** for debug information in readonly UT environment.--- begin ****

Line 4826: l_value3 jmf_shikyu_cfr_rpt_temp.value3%TYPE;

4822: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;
4823: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;
4824: l_value1 jmf_shikyu_cfr_rpt_temp.value1%TYPE;
4825: l_value2 jmf_shikyu_cfr_rpt_temp.value2%TYPE;
4826: l_value3 jmf_shikyu_cfr_rpt_temp.value3%TYPE;
4827:
4828: BEGIN
4829: -- **** for debug information in readonly UT environment.--- begin ****
4830: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => p_output_to

Line 4833: ,p_message => '==jmf_shikyu_cfr_rpt_temp data Begin==');

4829: -- **** for debug information in readonly UT environment.--- begin ****
4830: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => p_output_to
4831: ,p_api_name => G_MODULE_PREFIX ||
4832: l_api_name
4833: ,p_message => '==jmf_shikyu_cfr_rpt_temp data Begin==');
4834: -- **** for debug information in readonly UT environment.--- end ****
4835: OPEN l_cur_get_temp_data(p_rpt_data_type);
4836: LOOP
4837: --print the data in l_cur_get_mid_temp_data

Line 4876: ,p_message => 'jmf_shikyu_cfr_rpt_temp:' ||

4872: -- **** for debug information in readonly UT environment.--- begin ****
4873: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => p_output_to
4874: ,p_api_name => G_MODULE_PREFIX ||
4875: l_api_name
4876: ,p_message => 'jmf_shikyu_cfr_rpt_temp:' ||
4877: ';rpt_mode[' ||
4878: l_rpt_mode || ']' ||
4879: ';rpt_data_type[' ||
4880: l_rpt_data_type || ']' ||

Line 4942: ,p_message => '==jmf_shikyu_cfr_rpt_temp data end==');

4938: -- **** for debug information in readonly UT environment.--- begin ****
4939: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => p_output_to
4940: ,p_api_name => G_MODULE_PREFIX ||
4941: l_api_name
4942: ,p_message => '==jmf_shikyu_cfr_rpt_temp data end==');
4943: -- **** for debug information in readonly UT environment.--- end ****
4944:
4945: IF g_fnd_debug = 'Y'
4946: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL