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_MID_TEMP

Line 375: DELETE FROM JMF_SHIKYU_CFR_MID_TEMP;

371: RETURN;
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;

Line 690: INSERT INTO jmf_shikyu_cfr_mid_temp

686: -- get the onhand quantity for each TP inv org items.
687: -- for the specified tp_inv_org_id, find the items
688: -- insert the data into the mid temp table,
689: --???using the get_item_number function to get the flexfield values, or using segment1 for hardcoding?
690: INSERT INTO jmf_shikyu_cfr_mid_temp
691: (row_type --onhand row type
692: ,oem_inv_org_id --oem_inv_org_id
693: ,supplier_id --supplier_id
694: ,site_id --site_id

Line 786: -- COMMENT : for each line in the on hand data in the jmf_shikyu_cfr_mid_temp table,

782: -- : p_days_received received after the days ago
783: -- : p_sort_by By Supplier/Site or By Item, the External report can use only by Supplier/Site
784: -- : p_currency_conversion_type the currency conversion type
785: -- : p_currency_conversion_date the currency conversion date
786: -- COMMENT : for each line in the on hand data in the jmf_shikyu_cfr_mid_temp table,
787: -- this procedure is used to get the possilbe rcv_transaction data information
788: -- for those onhand SHIKYU components based on LIFO received date.
789: -- first the unallocated qty,then the allocated but unconsumed qty.
790: -- PRE-COND :

Line 807: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;

803: ,p_currency_conversion_date IN DATE
804: ) IS
805: l_api_name CONSTANT VARCHAR2(30) := 'get_rpt_confirmation_data';
806:
807: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
808: l_supplier_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
809: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
810: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
811: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;

Line 808: l_supplier_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;

804: ) IS
805: l_api_name CONSTANT VARCHAR2(30) := 'get_rpt_confirmation_data';
806:
807: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
808: l_supplier_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
809: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
810: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
811: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
812: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;

Line 809: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;

805: l_api_name CONSTANT VARCHAR2(30) := 'get_rpt_confirmation_data';
806:
807: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
808: l_supplier_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
809: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
810: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
811: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
812: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
813: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;

Line 810: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;

806:
807: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
808: l_supplier_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
809: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
810: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
811: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
812: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
813: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
814: l_onhand_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;

Line 811: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;

807: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
808: l_supplier_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
809: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
810: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
811: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
812: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
813: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
814: l_onhand_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
815: -- get on hand components information

Line 812: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;

808: l_supplier_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
809: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
810: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
811: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
812: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
813: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
814: l_onhand_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
815: -- get on hand components information
816: CURSOR l_cur_get_onhand_components IS

Line 813: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;

809: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
810: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
811: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
812: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
813: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
814: l_onhand_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
815: -- get on hand components information
816: CURSOR l_cur_get_onhand_components IS
817: SELECT supplier_id

Line 814: l_onhand_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;

810: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
811: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
812: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
813: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
814: l_onhand_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
815: -- get on hand components information
816: CURSOR l_cur_get_onhand_components IS
817: SELECT supplier_id
818: ,site_id

Line 825: FROM jmf_shikyu_cfr_mid_temp

821: ,item_id
822: ,project_id
823: ,task_id
824: ,primary_unconsumed_quantity
825: FROM jmf_shikyu_cfr_mid_temp
826: WHERE row_type = p_onhand_row_type;
827:
828: BEGIN
829: IF g_fnd_debug = 'Y' AND

Line 910: UPDATE jmf_shikyu_cfr_mid_temp

906: ,x_need_to_find_pri_qty => l_onhand_quantity);
907: END IF;
908:
909: -- record the l_onhand_quantity to column primary_unallocated_quantity
910: UPDATE jmf_shikyu_cfr_mid_temp
911: SET primary_unallocated_quantity = l_onhand_quantity
912: WHERE row_type = p_onhand_row_type
913: AND supplier_id = l_supplier_id
914: AND site_id = l_supplier_site_id

Line 982: -- COMMENT : for each line in the on hand data in the jmf_shikyu_cfr_mid_temp table,

978: -- : p_oem_inv_org_id the oem_inv_org_id got from the onhand info from mid temp table
979: -- : p_tp_inv_org_id the tp_inv_org_id got from the onhand info from mid temp table
980: -- : p_item_id the item_id got from the onhand info from mid temp table
981: -- : x_need_to_find_pri_qty the need to find quantity under primary UOM
982: -- COMMENT : for each line in the on hand data in the jmf_shikyu_cfr_mid_temp table,
983: -- this procedure is used to get the possilbe unallocated rcv_transaction data information
984: -- for those onhand SHIKYU components based on LIFO received date.
985: -- PRE-COND :
986: -- EXCEPTIONS:

Line 1005: -- decrease the rcv quantity processed and logged in the jmf_shikyu_cfr_mid_temp table.

1001: ) IS
1002: l_api_name CONSTANT VARCHAR2(30) := 'get_unallocated_components';
1003:
1004: -- get rcv_transaction information, rcv_transaction_id, rcv_unprocessed_qty
1005: -- decrease the rcv quantity processed and logged in the jmf_shikyu_cfr_mid_temp table.
1006: CURSOR l_cur_get_rcv_transaction_info IS
1007: SELECT rt.transaction_id
1008: -- Updated to fix potential issue of operations between null numbers
1009: -- ,rt.primary_quantity -

Line 1014: FROM jmf_shikyu_cfr_mid_temp jscmt_rcv

1010: ,NVL(rt.primary_quantity,0) -
1011: NVL((SELECT SUM(NVL(jscmt_rcv.primary_unallocated_quantity
1012: ,0) + NVL(jscmt_rcv.primary_unconsumed_quantity
1013: ,0))
1014: FROM jmf_shikyu_cfr_mid_temp jscmt_rcv
1015: WHERE jscmt_rcv.row_type = 40
1016: AND jscmt_rcv.shikyu_id = rt.transaction_id)
1017: ,0)
1018: --Added to fix bug 5509464 start

Line 1022: FROM jmf_shikyu_cfr_mid_temp mid

1018: --Added to fix bug 5509464 start
1019: ,pha.vendor_id --p_supplier_id
1020: ,pha.vendor_site_id --p_supplier_site_id
1021: --Added to fix bug 5509464 end
1022: FROM jmf_shikyu_cfr_mid_temp mid
1023: ,po_line_locations_all pll
1024: ,rcv_transactions rt
1025: --Added to fix bug 5509464 start
1026: ,po_headers_all pha

Line 1274: INSERT INTO jmf_shikyu_cfr_mid_temp

1270: -- if all parameters are valid then continue; otherwise raise an error message in log;
1271:
1272: -- the allocated quantity for one po line_location_id, change the UOM in po and shikyu allocation to primary UOM
1273: -- only insert the rep_po that not in mid temp table, if in the table already, keep the data.
1274: INSERT INTO jmf_shikyu_cfr_mid_temp
1275: (row_type
1276: ,shikyu_id
1277: ,uom
1278: ,primary_uom

Line 1348: FROM jmf_shikyu_cfr_mid_temp jscmt

1344: (pha.vendor_site_id IS NULL AND hoi.org_information4 IS NULL))
1345: AND pla.item_id = p_item_id
1346: AND plla.line_location_id NOT IN
1347: (SELECT jscmt.shikyu_id
1348: FROM jmf_shikyu_cfr_mid_temp jscmt
1349: WHERE jscmt.row_type = p_rep_po_unalloc_row_type
1350: AND jscmt.item_id = p_item_id
1351: AND jscmt.oem_inv_org_id = p_oem_inv_org_id
1352: AND jscmt.tp_inv_org_id = p_tp_inv_org_id

Line 1394: UPDATE jmf_shikyu_cfr_mid_temp

1390: AND po_uom_s.get_primary_uom(pla.item_id,p_tp_inv_org_id,null) = uom_tl_s.unit_of_measure -- primary UOM
1391: AND jsr.shikyu_component_id = p_item_id);
1392:
1393: --update the residual_unallocated(quantity) column under UOM.
1394: UPDATE jmf_shikyu_cfr_mid_temp
1395: SET quantity = NVL(primary_unallocated_quantity,0) *
1396: JMF_SHIKYU_RPT_UTIL.po_uom_convert_p(primary_uom
1397: ,uom
1398: ,item_id)

Line 1508: FROM jmf_shikyu_cfr_mid_temp cfr_mid

1504: -- Valid parameter validation;
1505: -- if all parameters are valid then continue; otherwise raise an error message in log;
1506: SELECT cfr_mid.primary_unallocated_quantity
1507: INTO l_rep_po_unallocated_pri
1508: FROM jmf_shikyu_cfr_mid_temp cfr_mid
1509: ,po_line_locations_all poloc
1510: ,rcv_transactions rcv
1511: WHERE rcv.transaction_type = 'RECEIVE'
1512: AND poloc.line_location_id = rcv.po_line_location_id

Line 1631: UPDATE jmf_shikyu_cfr_mid_temp

1627: END IF;
1628:
1629: -- Valid parameter validation;
1630: -- if all parameters are valid then continue; otherwise raise an error message in log;
1631: UPDATE jmf_shikyu_cfr_mid_temp
1632: -- Updated to fix potential issue of operations between null numbers
1633: --SET quantity = quantity -
1634: -- (quantity *
1635: SET quantity = NVL(quantity,0) -

Line 1762: FROM jmf_shikyu_cfr_mid_temp

1758: -- if all parameters are valid then continue; otherwise raise an error message in log;
1759: --????
1760: SELECT COUNT(*)
1761: INTO l_jmf_cfr_mid_temp_rcv_rows
1762: FROM jmf_shikyu_cfr_mid_temp
1763: WHERE row_type = p_rcv_row_type
1764: AND shikyu_id = p_rcv_transaction_id;
1765: --find if there is a rcv_transaction line exist
1766: IF l_jmf_cfr_mid_temp_rcv_rows = 1 --Found one row

Line 1769: UPDATE jmf_shikyu_cfr_mid_temp

1765: --find if there is a rcv_transaction line exist
1766: IF l_jmf_cfr_mid_temp_rcv_rows = 1 --Found one row
1767: THEN
1768: --update if exist
1769: UPDATE jmf_shikyu_cfr_mid_temp
1770: -- Updated to fix potential issue of operations between null numbers
1771: -- SET primary_unallocated_quantity = primary_unallocated_quantity +
1772: SET primary_unallocated_quantity = NVL(primary_unallocated_quantity,0) +
1773: p_rcv_unallocated_pri

Line 1779: INSERT INTO jmf_shikyu_cfr_mid_temp

1775: AND shikyu_id = p_rcv_transaction_id;
1776: ELSE
1777: --NOTFOUND
1778: --add if not exist
1779: INSERT INTO jmf_shikyu_cfr_mid_temp
1780: (row_type
1781: ,shikyu_id
1782: ,primary_unallocated_quantity
1783: ,oem_inv_org_id

Line 1847: -- COMMENT : for each line in the on hand data in the jmf_shikyu_cfr_mid_temp table,

1843: -- : p_oem_inv_org_id the oem_inv_org_id got from the onhand info from mid temp table
1844: -- : p_tp_inv_org_id the tp_inv_org_id got from the onhand info from mid temp table
1845: -- : p_item_id the item_id got from the onhand info from mid temp table
1846: -- : x_need_to_find_pri_qty the need to find quantity under primary UOM
1847: -- COMMENT : for each line in the on hand data in the jmf_shikyu_cfr_mid_temp table,
1848: -- this procedure is used to get the possilbe allocated but unconsumed rcv_transaction data information
1849: -- for those onhand SHIKYU components based on LIFO received date.
1850: -- PRE-COND :
1851: -- EXCEPTIONS:

Line 1881: FROM jmf_shikyu_cfr_mid_temp mid_s

1877: ,rt.primary_quantity -
1878: NVL((SELECT SUM(NVL(mid_s.primary_unallocated_quantity
1879: ,0) + NVL(mid_s.primary_unconsumed_quantity
1880: ,0))
1881: FROM jmf_shikyu_cfr_mid_temp mid_s
1882: WHERE mid_s.row_type = p_rcv_transaction_row_type
1883: AND mid_s.shikyu_id = rt.transaction_id)
1884: ,0)
1885: FROM jmf_shikyu_allocations alloc

Line 1887: ,jmf_shikyu_cfr_mid_temp mid

1883: AND mid_s.shikyu_id = rt.transaction_id)
1884: ,0)
1885: FROM jmf_shikyu_allocations alloc
1886: ,jmf_shikyu_replenishments jsr
1887: ,jmf_shikyu_cfr_mid_temp mid
1888: ,rcv_transactions rt
1889: WHERE mid.row_type = p_sub_po_unconsumed_row_type
1890: AND NVL(mid.get_rep_flag
1891: ,'N') <> CFR_REP_PO_GET_RCV_FLAG --if the rep_po line have done get rcv process, the get_rcv_flag will be set to 1

Line 2123: INSERT INTO jmf_shikyu_cfr_mid_temp

2119: -- if all parameters are valid then continue; otherwise raise an error message in log;
2120: --the subcontract orders that not fully received
2121:
2122: -- insert only the new SubPO info
2123: INSERT INTO jmf_shikyu_cfr_mid_temp
2124: (row_type
2125: ,shikyu_id
2126: ,uom
2127: ,primary_uom

Line 2182: FROM jmf_shikyu_cfr_mid_temp jscmt_s

2178: -- secondly,will be lost in them mid_temp table.That means in the report will lose some datas which should be displayed.
2179: -- updated to fix this potensial issue.
2180: /* AND NOT ((comp.subcontract_po_shipment_id IN
2181: (SELECT jscmt_s.shikyu_id
2182: FROM jmf_shikyu_cfr_mid_temp jscmt_s
2183: WHERE jscmt_s.row_type = p_sub_po_unconsumed_row_type)) AND
2184: (comp.shikyu_component_id IN
2185: (SELECT jscmt_i.item_id
2186: FROM jmf_shikyu_cfr_mid_temp jscmt_i

Line 2186: FROM jmf_shikyu_cfr_mid_temp jscmt_i

2182: FROM jmf_shikyu_cfr_mid_temp jscmt_s
2183: WHERE jscmt_s.row_type = p_sub_po_unconsumed_row_type)) AND
2184: (comp.shikyu_component_id IN
2185: (SELECT jscmt_i.item_id
2186: FROM jmf_shikyu_cfr_mid_temp jscmt_i
2187: WHERE jscmt_i.row_type = p_sub_po_unconsumed_row_type)))*/
2188: AND NOT (comp.subcontract_po_shipment_id IN
2189: (SELECT jscmt_s.shikyu_id
2190: FROM jmf_shikyu_cfr_mid_temp jscmt_s

Line 2190: FROM jmf_shikyu_cfr_mid_temp jscmt_s

2186: FROM jmf_shikyu_cfr_mid_temp jscmt_i
2187: WHERE jscmt_i.row_type = p_sub_po_unconsumed_row_type)))*/
2188: AND NOT (comp.subcontract_po_shipment_id IN
2189: (SELECT jscmt_s.shikyu_id
2190: FROM jmf_shikyu_cfr_mid_temp jscmt_s
2191: WHERE jscmt_s.row_type = p_sub_po_unconsumed_row_type
2192: AND jscmt_s.item_id = p_item_id))
2193: ;
2194:

Line 2196: UPDATE jmf_shikyu_cfr_mid_temp

2192: AND jscmt_s.item_id = p_item_id))
2193: ;
2194:
2195: --update the primary UOM, primary_residual_unallocated
2196: UPDATE jmf_shikyu_cfr_mid_temp
2197: SET quantity = NVL(primary_unconsumed_quantity,0) *
2198: JMF_SHIKYU_RPT_UTIL.po_uom_convert_p(primary_uom
2199: ,uom
2200: ,item_id)

Line 2310: INSERT INTO jmf_shikyu_cfr_mid_temp

2306:
2307: -- the allocated quantity for one po line_location_id, assume that the UOM are the same in po and shikyu allocation
2308: -- need to add the supplier/site oem tp org and item restriction????.
2309: -- update 2005-11-30
2310: INSERT INTO jmf_shikyu_cfr_mid_temp
2311: (row_type
2312: ,shikyu_id
2313: ,uom
2314: ,primary_uom

Line 2339: ,jmf_shikyu_cfr_mid_temp mid

2335: ,jsr.tp_organization_id
2336: ,alloc.shikyu_component_id
2337: FROM jmf_shikyu_allocations alloc
2338: ,jmf_shikyu_replenishments jsr
2339: ,jmf_shikyu_cfr_mid_temp mid
2340: ,jmf_subcontract_orders jso
2341: ,wip_requirement_operations wro
2342: WHERE mid.row_type = p_sub_po_unconsumed_row_type
2343: AND NVL(mid.get_rep_flag

Line 2367: FROM jmf_shikyu_cfr_mid_temp jscmt_s

2363: -- updated to fix this potensial issue.
2364: /* AND NOT
2365: ((jsr.replenishment_po_shipment_id IN
2366: (SELECT jscmt_s.shikyu_id
2367: FROM jmf_shikyu_cfr_mid_temp jscmt_s
2368: WHERE jscmt_s.row_type = p_rep_po_unconsumed_row_type)) AND
2369: (alloc.shikyu_component_id IN
2370: (SELECT jscmt_i.item_id
2371: FROM jmf_shikyu_cfr_mid_temp jscmt_i

Line 2371: FROM jmf_shikyu_cfr_mid_temp jscmt_i

2367: FROM jmf_shikyu_cfr_mid_temp jscmt_s
2368: WHERE jscmt_s.row_type = p_rep_po_unconsumed_row_type)) AND
2369: (alloc.shikyu_component_id IN
2370: (SELECT jscmt_i.item_id
2371: FROM jmf_shikyu_cfr_mid_temp jscmt_i
2372: WHERE jscmt_i.row_type = p_rep_po_unconsumed_row_type)));
2373: */ AND NOT (jsr.replenishment_po_shipment_id IN
2374: (SELECT jscmt_s.shikyu_id
2375: FROM jmf_shikyu_cfr_mid_temp jscmt_s

Line 2375: FROM jmf_shikyu_cfr_mid_temp jscmt_s

2371: FROM jmf_shikyu_cfr_mid_temp jscmt_i
2372: WHERE jscmt_i.row_type = p_rep_po_unconsumed_row_type)));
2373: */ AND NOT (jsr.replenishment_po_shipment_id IN
2374: (SELECT jscmt_s.shikyu_id
2375: FROM jmf_shikyu_cfr_mid_temp jscmt_s
2376: WHERE jscmt_s.row_type = p_rep_po_unconsumed_row_type
2377: AND jscmt_s.item_id = p_item_id));
2378:
2379: --update the primary UOM, primary_residual_unallocated

Line 2380: UPDATE jmf_shikyu_cfr_mid_temp

2376: WHERE jscmt_s.row_type = p_rep_po_unconsumed_row_type
2377: AND jscmt_s.item_id = p_item_id));
2378:
2379: --update the primary UOM, primary_residual_unallocated
2380: UPDATE jmf_shikyu_cfr_mid_temp
2381: SET quantity = NVL(primary_unconsumed_quantity,0) *
2382: JMF_SHIKYU_RPT_UTIL.po_uom_convert_p(primary_uom
2383: ,uom
2384: ,item_id)

Line 2494: FROM jmf_shikyu_cfr_mid_temp cfr_mid

2490: -- if all parameters are valid then continue; otherwise raise an error message in log;
2491: SELECT SUM(NVL(cfr_mid.primary_unconsumed_quantity
2492: ,0))
2493: INTO l_sub_po_residual_pri
2494: FROM jmf_shikyu_cfr_mid_temp cfr_mid
2495: ,rcv_transactions rcv
2496: ,jmf_shikyu_allocations alloc
2497: ,jmf_shikyu_replenishments jsr
2498: WHERE rcv.transaction_id = P_rcv_transaction_id

Line 2581: FROM jmf_shikyu_cfr_mid_temp cfr_mid

2577:
2578: CURSOR lcur_sub_po_temp_info IS
2579: SELECT cfr_mid.shikyu_id
2580: ,cfr_mid.primary_unconsumed_quantity
2581: FROM jmf_shikyu_cfr_mid_temp cfr_mid
2582: ,rcv_transactions rcv
2583: ,jmf_shikyu_allocations alloc
2584: ,jmf_shikyu_replenishments jsr
2585: WHERE rcv.transaction_id = p_rcv_transaction_id

Line 2600: l_sub_po_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;

2596: AND jsr.replenishment_po_shipment_id = rcv.po_line_location_id
2597: AND cfr_mid.primary_unconsumed_quantity > 0
2598: ORDER BY cfr_mid.shikyu_id DESC;
2599:
2600: l_sub_po_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
2601: l_residual_old_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2602: l_residual_new_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2603: l_cur_sub_po_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2604: BEGIN

Line 2601: l_residual_old_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;

2597: AND cfr_mid.primary_unconsumed_quantity > 0
2598: ORDER BY cfr_mid.shikyu_id DESC;
2599:
2600: l_sub_po_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
2601: l_residual_old_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2602: l_residual_new_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2603: l_cur_sub_po_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2604: BEGIN
2605: -- **** for debug information in readonly UT environment.--- begin ****

Line 2602: l_residual_new_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;

2598: ORDER BY cfr_mid.shikyu_id DESC;
2599:
2600: l_sub_po_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
2601: l_residual_old_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2602: l_residual_new_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2603: l_cur_sub_po_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2604: BEGIN
2605: -- **** for debug information in readonly UT environment.--- begin ****
2606: JMF_SHIKYU_RPT_UTIL.debug_output

Line 2603: l_cur_sub_po_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;

2599:
2600: l_sub_po_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
2601: l_residual_old_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2602: l_residual_new_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2603: l_cur_sub_po_consumed_pri jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
2604: BEGIN
2605: -- **** for debug information in readonly UT environment.--- begin ****
2606: JMF_SHIKYU_RPT_UTIL.debug_output
2607: (

Line 2662: UPDATE jmf_shikyu_cfr_mid_temp

2658: -- **** for debug information in readonly UT environment.--- end ****
2659:
2660: l_cur_sub_po_consumed_pri := jmf_shikyu_rpt_util.get_min2(l_residual_old_consumed_pri
2661: ,l_residual_new_consumed_pri);
2662: UPDATE jmf_shikyu_cfr_mid_temp
2663: -- Updated to fix potential issue of operations between null numbers
2664: -- SET quantity = quantity -
2665: -- (quantity * l_cur_sub_po_consumed_pri /
2666: SET quantity = NVL(quantity,0) -

Line 2790: FROM jmf_shikyu_cfr_mid_temp

2786: -- Valid parameter validation;
2787: -- if all parameters are valid then continue; otherwise raise an error message in log;
2788: SELECT COUNT(*)
2789: INTO l_jmf_cfr_mid_temp_rcv_rows
2790: FROM jmf_shikyu_cfr_mid_temp
2791: WHERE row_type = p_rcv_row_type
2792: AND shikyu_id = p_rcv_transaction_id;
2793: --find if there is a rcv_transaction line exist
2794: IF l_jmf_cfr_mid_temp_rcv_rows = 1 --Found one row

Line 2797: UPDATE jmf_shikyu_cfr_mid_temp

2793: --find if there is a rcv_transaction line exist
2794: IF l_jmf_cfr_mid_temp_rcv_rows = 1 --Found one row
2795: THEN
2796: --update if exist
2797: UPDATE jmf_shikyu_cfr_mid_temp
2798: -- Updated to fix potential issue of operations between null numbers
2799: -- SET primary_unconsumed_quantity = primary_unconsumed_quantity +
2800: SET primary_unconsumed_quantity = NVL(primary_unconsumed_quantity,0) +
2801: p_rcv_unconsumed_pri

Line 2807: INSERT INTO jmf_shikyu_cfr_mid_temp

2803: AND shikyu_id = p_rcv_transaction_id;
2804: ELSE
2805: --NOTFOUND
2806: --add if not exist
2807: INSERT INTO jmf_shikyu_cfr_mid_temp
2808: (row_type
2809: ,shikyu_id
2810: ,primary_unconsumed_quantity
2811: ,oem_inv_org_id

Line 2895: UPDATE jmf_shikyu_cfr_mid_temp jscmt

2891: , 'p_rcv_row_type:' || p_rcv_row_type);
2892: END IF;
2893:
2894: -- fill the uom, primary_uom column for CFR_TMP_RCV_ROW rows
2895: UPDATE jmf_shikyu_cfr_mid_temp jscmt
2896: SET jscmt.uom = (SELECT rt.unit_of_measure
2897: FROM rcv_transactions rt
2898: WHERE jscmt.row_type = CFR_TMP_RCV_ROW
2899: AND rt.transaction_id = jscmt.shikyu_id)

Line 2907: UPDATE jmf_shikyu_cfr_mid_temp

2903: AND rt.transaction_id = jscmt.shikyu_id)
2904: WHERE jscmt.row_type = CFR_TMP_RCV_ROW;
2905: -- update the quantity column for CFR_TMP_RCV_ROW rows
2906: -- quantity of UOM =
2907: UPDATE jmf_shikyu_cfr_mid_temp
2908: SET quantity = (NVL(primary_unallocated_quantity
2909: ,0) + NVL(primary_unconsumed_quantity
2910: ,0)) *
2911: JMF_SHIKYU_RPT_UTIL.po_uom_convert_p(JMF_SHIKYU_RPT_UTIL.uom_to_code(primary_uom)

Line 3280: FROM jmf_shikyu_cfr_mid_temp cfr_mid

3276: ,pra_s.po_release_id SubPO_release_id
3277: ,pra_s.release_num SubPO_release_Num
3278: ,plla_s.line_location_id SubPO_shipment_id
3279: ,plla_s.shipment_num SubPO_shipment_num
3280: FROM jmf_shikyu_cfr_mid_temp cfr_mid
3281: ,jmf_subcontract_orders sub
3282: ,po_line_locations_all poloc
3283: ,rcv_transactions rcv
3284: ,mtl_parameters mp_oem

Line 3578: FROM jmf_shikyu_cfr_mid_temp jscmt

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
3578: FROM jmf_shikyu_cfr_mid_temp jscmt
3579: WHERE jscmt.row_type = CFR_TMP_ONHAND_ROW --10
3580: AND jscmt.tp_inv_org_id =
3581: jscrt.tp_inv_org_id
3582: AND jscmt.item_id = jscrt.item_id),

Line 3584: FROM jmf_shikyu_cfr_mid_temp jscmt

3580: AND jscmt.tp_inv_org_id =
3581: jscrt.tp_inv_org_id
3582: AND jscmt.item_id = jscrt.item_id),
3583: jscrt.value1 = (SELECT jscmt.primary_unconsumed_quantity
3584: FROM jmf_shikyu_cfr_mid_temp jscmt
3585: WHERE jscmt.row_type = CFR_TMP_ONHAND_ROW --10
3586: AND jscmt.tp_inv_org_id =
3587: jscrt.tp_inv_org_id
3588: AND jscmt.item_id = jscrt.item_id)

Line 3752: from jmf_shikyu_cfr_mid_temp cfr_mid_temp

3748: ,cfr_mid_temp.tp_inv_org_id tp_inv_org_id
3749: ,cfr_mid_temp.item_id item_id
3750: ,cfr_mid_temp.uom
3751: ,cfr_mid_temp.primary_uom
3752: from jmf_shikyu_cfr_mid_temp cfr_mid_temp
3753: where cfr_mid_temp.row_type = CFR_TMP_RCV_ROW) cfr_mid_item_group
3754: ,jmf_shikyu_replenishments jsr
3755: ,jmf_shikyu_allocations jsa
3756: ,oe_order_lines_all oola

Line 4430: FROM jmf_shikyu_cfr_mid_temp jscmt

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
4430: FROM jmf_shikyu_cfr_mid_temp jscmt
4431: WHERE jscmt.row_type = CFR_TMP_ONHAND_ROW --10
4432: AND jscmt.tp_inv_org_id =
4433: jscrt.tp_inv_org_id
4434: AND jscmt.item_id = jscrt.item_id),

Line 4436: FROM jmf_shikyu_cfr_mid_temp jscmt

4432: AND jscmt.tp_inv_org_id =
4433: jscrt.tp_inv_org_id
4434: AND jscmt.item_id = jscrt.item_id),
4435: jscrt.value1 = (SELECT jscmt.primary_unconsumed_quantity
4436: FROM jmf_shikyu_cfr_mid_temp jscmt
4437: WHERE jscmt.row_type = CFR_TMP_ONHAND_ROW --10
4438: AND jscmt.tp_inv_org_id =
4439: jscrt.tp_inv_org_id
4440: AND jscmt.item_id = jscrt.item_id)

Line 4595: -- PARAMETERS: p_row_type row type in jmf_shikyu_cfr_mid_temp

4591: END rpt_get_SubPO_data_Onhand;
4592:
4593: --========================================================================
4594: -- PROCEDURE : rpt_debug_show_mid_data PUBLIC ,
4595: -- PARAMETERS: p_row_type row type in jmf_shikyu_cfr_mid_temp
4596: -- p_output_to the parameter for debug_output
4597: -- COMMENT : show the data in temp table jmf_shikyu_cfr_mid_temp
4598: -- using debug_output
4599: -- PRE-COND :

Line 4597: -- COMMENT : show the data in temp table jmf_shikyu_cfr_mid_temp

4593: --========================================================================
4594: -- PROCEDURE : rpt_debug_show_mid_data PUBLIC ,
4595: -- PARAMETERS: p_row_type row type in jmf_shikyu_cfr_mid_temp
4596: -- p_output_to the parameter for debug_output
4597: -- COMMENT : show the data in temp table jmf_shikyu_cfr_mid_temp
4598: -- using debug_output
4599: -- PRE-COND :
4600: -- EXCEPTIONS:
4601: --========================================================================

Line 4609: CURSOR l_cur_get_mid_temp_data(lp_row_type jmf_shikyu_cfr_mid_temp.row_type%TYPE) IS

4605: ,p_output_to IN VARCHAR2
4606: ) IS
4607: l_api_name CONSTANT VARCHAR2(30) := 'rpt_debug_show_mid_data';
4608:
4609: CURSOR l_cur_get_mid_temp_data(lp_row_type jmf_shikyu_cfr_mid_temp.row_type%TYPE) IS
4610: SELECT row_type
4611: ,shikyu_id
4612: ,tp_inv_org_id
4613: ,item_id

Line 4627: FROM jmf_shikyu_cfr_mid_temp

4623: ,site_id
4624: ,ou_id
4625: ,get_rcv_flag
4626: ,get_rep_flag
4627: FROM jmf_shikyu_cfr_mid_temp
4628: WHERE (lp_row_type IS NULL)
4629: OR (row_type = lp_row_type)
4630: ORDER BY row_type
4631: ,shikyu_id

Line 4634: l_row_type jmf_shikyu_cfr_mid_temp.row_type%TYPE;

4630: ORDER BY row_type
4631: ,shikyu_id
4632: ,item_id;
4633:
4634: l_row_type jmf_shikyu_cfr_mid_temp.row_type%TYPE;
4635: l_shikyu_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
4636: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
4637: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;

Line 4635: l_shikyu_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;

4631: ,shikyu_id
4632: ,item_id;
4633:
4634: l_row_type jmf_shikyu_cfr_mid_temp.row_type%TYPE;
4635: l_shikyu_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
4636: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
4637: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;
4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;

Line 4636: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;

4632: ,item_id;
4633:
4634: l_row_type jmf_shikyu_cfr_mid_temp.row_type%TYPE;
4635: l_shikyu_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
4636: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
4637: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;
4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;
4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;

Line 4637: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;

4633:
4634: l_row_type jmf_shikyu_cfr_mid_temp.row_type%TYPE;
4635: l_shikyu_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
4636: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
4637: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;
4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;
4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;
4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;

Line 4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;

4634: l_row_type jmf_shikyu_cfr_mid_temp.row_type%TYPE;
4635: l_shikyu_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
4636: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
4637: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;
4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;
4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;
4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;
4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;

Line 4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;

4635: l_shikyu_id jmf_shikyu_cfr_mid_temp.shikyu_id%TYPE;
4636: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
4637: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;
4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;
4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;
4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;
4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;

Line 4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;

4636: l_tp_inv_org_id jmf_shikyu_cfr_mid_temp.tp_inv_org_id%TYPE;
4637: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;
4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;
4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;
4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;
4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;

Line 4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;

4637: l_item_id jmf_shikyu_cfr_mid_temp.item_id%TYPE;
4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;
4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;
4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;
4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;
4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;

Line 4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;

4638: l_uom jmf_shikyu_cfr_mid_temp.uom%TYPE;
4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;
4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;
4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;
4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;

Line 4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;

4639: l_quantity jmf_shikyu_cfr_mid_temp.quantity%TYPE;
4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;
4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;
4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
4647: l_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;

Line 4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;

4640: l_primary_uom jmf_shikyu_cfr_mid_temp.primary_uom%TYPE;
4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;
4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
4647: l_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
4648: l_ou_id jmf_shikyu_cfr_mid_temp.ou_id%TYPE;

Line 4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;

4641: l_primary_unallocated_quantity jmf_shikyu_cfr_mid_temp.primary_unallocated_quantity%TYPE;
4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
4647: l_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
4648: l_ou_id jmf_shikyu_cfr_mid_temp.ou_id%TYPE;
4649: l_get_rcv_flag jmf_shikyu_cfr_mid_temp.get_rcv_flag%TYPE;

Line 4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;

4642: l_primary_unconsumed_quantity jmf_shikyu_cfr_mid_temp.primary_unconsumed_quantity%TYPE;
4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
4647: l_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
4648: l_ou_id jmf_shikyu_cfr_mid_temp.ou_id%TYPE;
4649: l_get_rcv_flag jmf_shikyu_cfr_mid_temp.get_rcv_flag%TYPE;
4650: l_get_rep_flag jmf_shikyu_cfr_mid_temp.get_rep_flag%TYPE;

Line 4647: l_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;

4643: l_project_id jmf_shikyu_cfr_mid_temp.project_id%TYPE;
4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
4647: l_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
4648: l_ou_id jmf_shikyu_cfr_mid_temp.ou_id%TYPE;
4649: l_get_rcv_flag jmf_shikyu_cfr_mid_temp.get_rcv_flag%TYPE;
4650: l_get_rep_flag jmf_shikyu_cfr_mid_temp.get_rep_flag%TYPE;
4651:

Line 4648: l_ou_id jmf_shikyu_cfr_mid_temp.ou_id%TYPE;

4644: l_task_id jmf_shikyu_cfr_mid_temp.task_id%TYPE;
4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
4647: l_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
4648: l_ou_id jmf_shikyu_cfr_mid_temp.ou_id%TYPE;
4649: l_get_rcv_flag jmf_shikyu_cfr_mid_temp.get_rcv_flag%TYPE;
4650: l_get_rep_flag jmf_shikyu_cfr_mid_temp.get_rep_flag%TYPE;
4651:
4652: BEGIN

Line 4649: l_get_rcv_flag jmf_shikyu_cfr_mid_temp.get_rcv_flag%TYPE;

4645: l_oem_inv_org_id jmf_shikyu_cfr_mid_temp.oem_inv_org_id%TYPE;
4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
4647: l_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
4648: l_ou_id jmf_shikyu_cfr_mid_temp.ou_id%TYPE;
4649: l_get_rcv_flag jmf_shikyu_cfr_mid_temp.get_rcv_flag%TYPE;
4650: l_get_rep_flag jmf_shikyu_cfr_mid_temp.get_rep_flag%TYPE;
4651:
4652: BEGIN
4653: -- **** for debug information in readonly UT environment.--- begin ****

Line 4650: l_get_rep_flag jmf_shikyu_cfr_mid_temp.get_rep_flag%TYPE;

4646: l_supplier_id jmf_shikyu_cfr_mid_temp.supplier_id%TYPE;
4647: l_site_id jmf_shikyu_cfr_mid_temp.site_id%TYPE;
4648: l_ou_id jmf_shikyu_cfr_mid_temp.ou_id%TYPE;
4649: l_get_rcv_flag jmf_shikyu_cfr_mid_temp.get_rcv_flag%TYPE;
4650: l_get_rep_flag jmf_shikyu_cfr_mid_temp.get_rep_flag%TYPE;
4651:
4652: BEGIN
4653: -- **** for debug information in readonly UT environment.--- begin ****
4654: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => p_output_to

Line 4657: ,p_message => '==jmf_shikyu_cfr_mid_temp data Begin==');

4653: -- **** for debug information in readonly UT environment.--- begin ****
4654: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => p_output_to
4655: ,p_api_name => G_MODULE_PREFIX ||
4656: l_api_name
4657: ,p_message => '==jmf_shikyu_cfr_mid_temp data Begin==');
4658: -- **** for debug information in readonly UT environment.--- end ****
4659: OPEN l_cur_get_mid_temp_data(p_row_type);
4660: LOOP
4661: --print the data in l_cur_get_mid_temp_data

Line 4687: ,p_message => 'jmf_shikyu_cfr_mid_temp:' ||

4683: -- **** for debug information in readonly UT environment.--- begin ****
4684: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => p_output_to
4685: ,p_api_name => G_MODULE_PREFIX ||
4686: l_api_name
4687: ,p_message => 'jmf_shikyu_cfr_mid_temp:' ||
4688: ';row_type[' || l_row_type || ']' ||
4689: ';shikyu_id[' || l_shikyu_id || ']' ||
4690: ';tp_inv_org_id[' || l_tp_inv_org_id || ']' ||
4691: ';item_id[' || l_item_id || ']' ||

Line 4715: ,p_message => '==jmf_shikyu_cfr_mid_temp data end==');

4711: -- **** for debug information in readonly UT environment.--- begin ****
4712: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => p_output_to
4713: ,p_api_name => G_MODULE_PREFIX ||
4714: l_api_name
4715: ,p_message => '==jmf_shikyu_cfr_mid_temp data end==');
4716: -- **** for debug information in readonly UT environment.--- end ****
4717:
4718: IF g_fnd_debug = 'Y' AND
4719: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL