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 3387: -- COMMENT : get the Component Estimated data into jmf_shikyu_cfr_rpt_temp with

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

Line 3410: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

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

Line 3454: FROM JMF_SHIKYU_CFR_RPT_TEMP temp

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

Line 3512: FROM JMF_SHIKYU_CFR_RPT_TEMP rpt_temp

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

Line 3570: /* UPDATE JMF_SHIKYU_CFR_RPT_TEMP jscrt

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

Line 3593: UPDATE JMF_SHIKYU_CFR_RPT_TEMP temp

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

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

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

Line 3676: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

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

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

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

Line 3865: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

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

Line 3939: FROM JMF_SHIKYU_CFR_RPT_TEMP jscrt

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

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

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

Line 4037: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

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

Line 4104: FROM JMF_SHIKYU_CFR_RPT_TEMP jscrt

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

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

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

Line 4179: INSERT INTO jmf_shikyu_cfr_rpt_temp

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

Line 4247: FROM jmf_shikyu_cfr_rpt_temp jscrt

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

Line 4341: FROM jmf_shikyu_cfr_rpt_temp jscrt

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

Line 4422: /* UPDATE JMF_SHIKYU_CFR_RPT_TEMP jscrt

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

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

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

Line 4501: INSERT INTO JMF_SHIKYU_CFR_RPT_TEMP

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

Line 4548: FROM JMF_SHIKYU_CFR_RPT_TEMP temp

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

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

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

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

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

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

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

Line 4785: FROM jmf_shikyu_cfr_rpt_temp

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

Line 4794: l_rpt_mode jmf_shikyu_cfr_rpt_temp.rpt_mode%TYPE;

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

Line 4795: l_rpt_data_type jmf_shikyu_cfr_rpt_temp.rpt_data_type%TYPE;

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

Line 4796: l_oem_inv_org_id jmf_shikyu_cfr_rpt_temp.oem_inv_org_id%TYPE;

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

Line 4797: l_oem_inv_org_code jmf_shikyu_cfr_rpt_temp.oem_inv_org_code%TYPE;

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

Line 4798: l_oem_inv_org_name jmf_shikyu_cfr_rpt_temp.oem_inv_org_name%TYPE;

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

Line 4799: l_oem_inv_org_address jmf_shikyu_cfr_rpt_temp.oem_inv_org_address%TYPE;

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

Line 4800: l_supplier_id jmf_shikyu_cfr_rpt_temp.supplier_id%TYPE;

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

Line 4801: l_supplier_name jmf_shikyu_cfr_rpt_temp.supplier_name%TYPE;

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

Line 4802: l_site_id jmf_shikyu_cfr_rpt_temp.site_id%TYPE;

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

Line 4803: l_site_code jmf_shikyu_cfr_rpt_temp.site_code%TYPE;

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

Line 4804: l_site_address jmf_shikyu_cfr_rpt_temp.site_address%TYPE;

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

Line 4805: l_tp_inv_org_id jmf_shikyu_cfr_rpt_temp.tp_inv_org_id%TYPE;

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

Line 4806: l_tp_inv_org_code jmf_shikyu_cfr_rpt_temp.tp_inv_org_code%TYPE;

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

Line 4807: l_project_id jmf_shikyu_cfr_rpt_temp.project_id%TYPE;

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

Line 4808: l_project_num jmf_shikyu_cfr_rpt_temp.project_num%TYPE;

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

Line 4809: l_task_id jmf_shikyu_cfr_rpt_temp.task_id%TYPE;

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

Line 4810: l_task_num jmf_shikyu_cfr_rpt_temp.task_num%TYPE;

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

Line 4811: l_item_id jmf_shikyu_cfr_rpt_temp.item_id%TYPE;

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

Line 4812: l_item_number jmf_shikyu_cfr_rpt_temp.item_number%TYPE;

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

Line 4813: l_item_description jmf_shikyu_cfr_rpt_temp.item_description%TYPE;

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

Line 4814: l_estimated_qty jmf_shikyu_cfr_rpt_temp.estimated_qty%TYPE;

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

Line 4815: l_primary_uom jmf_shikyu_cfr_rpt_temp.primary_uom%TYPE;

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

Line 4816: l_shikyu_price jmf_shikyu_cfr_rpt_temp.shikyu_price%TYPE;

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

Line 4817: l_currency_code jmf_shikyu_cfr_rpt_temp.currency_code%TYPE;

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

Line 4818: l_uom jmf_shikyu_cfr_rpt_temp.uom%TYPE;

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

Line 4819: l_item_cost jmf_shikyu_cfr_rpt_temp.item_cost%TYPE;

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

Line 4820: l_functional_currency jmf_shikyu_cfr_rpt_temp.functional_currency%TYPE;

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

Line 4821: l_value1 jmf_shikyu_cfr_rpt_temp.value1%TYPE;

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

Line 4822: l_value2 jmf_shikyu_cfr_rpt_temp.value2%TYPE;

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

Line 4823: l_value3 jmf_shikyu_cfr_rpt_temp.value3%TYPE;

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

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

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

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

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

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

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