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 RCV_TRANSACTIONS

Line 79: --| 07-SEP-2006 amy updated procedure rpt_get_crude_data to fix bug 5510828(get project id for table sub not from rcv transactions) |

75: --| instead of get those subPOs causing onhand Qty |
76: --| Added global variable g_ou_id to pass ou infro to procedure rpt_get_SubPO_data |
77: --| Added global variable CFR_EXT_SUBPO_AFT_ONHAND to identify original subpo data in rpt_temp table |
78: --| 28-JUNE-2006 amy updated procedure rpt_get_SubPO_data to fix bug 5415777 |
79: --| 07-SEP-2006 amy updated procedure rpt_get_crude_data to fix bug 5510828(get project id for table sub not from rcv transactions) |
80: --| updated procedure rpt_get_Comp_Estimated_data to fix bug 5510828(insert project_num/task_num information into rpt temp data(100) |
81: --| updated procedure rpt_get_SubPo_data to fix bug 5510828(insert project_num/task_num information into rpt temp data(110) |
82: --| 18-SEP-2006 amy updated procedure get_unallocated_components to fix bug 5509464(get vendor_id/vendor_site_id from repleninshment po information in receiving transaction query) |
83: --| updated procedure get_unallocated_rep_po to fix bug 5509464(updated sql query criteria to cover the cases when having some rep POs have corresponding rep SOs |

Line 172: CFR_REP_PO_GET_RCV_FLAG CONSTANT VARCHAR2(1) := 'Y'; --this rep_po line has been used for get_rcv_transactions

168: CFR_TMP_SUB_PO_UNCONSUMED_ROW CONSTANT NUMBER := 40; --The subcontracting purchase order info
169: CFR_TMP_RCV_ROW CONSTANT NUMBER := 50; --The receive transactions info
170:
171: --the constant for temporary table get_rcv_flag for confirmation report
172: CFR_REP_PO_GET_RCV_FLAG CONSTANT VARCHAR2(1) := 'Y'; --this rep_po line has been used for get_rcv_transactions
173: CFR_SUB_PO_GET_REP_FLAG CONSTANT VARCHAR2(1) := 'Y'; --this sub_po line has been used for get_replenishment po
174:
175: -- Bug 5665334
176: --========================================================================

Line 858: --find unallocated and allocated but unconsumed rcv_transactions for the inv_org,item.

854: -- Valid parameter validation;
855: -- if all parameters are valid then continue; otherwise raise an error message in log;
856: OPEN l_cur_get_onhand_components;
857: LOOP
858: --find unallocated and allocated but unconsumed rcv_transactions for the inv_org,item.
859: FETCH l_cur_get_onhand_components
860: INTO l_supplier_id, l_supplier_site_id, l_oem_inv_org_id, l_tp_inv_org_id, l_item_id, l_project_id, l_task_id, l_onhand_quantity;
861:
862: EXIT WHEN l_cur_get_onhand_components%NOTFOUND;

Line 879: --get the unallocated rcv_transactions

875: ',l_onhand_quantity:' || l_onhand_quantity
876: );
877: -- **** for debug information in readonly UT environment.--- end ****
878:
879: --get the unallocated rcv_transactions
880: get_unallocated_components(p_rep_po_unalloc_row_type => p_rep_po_unalloc_row_type
881: ,p_rcv_transaction_row_type => p_rcv_transaction_row_type
882: ,p_ou_id => p_ou_id
883: ,p_supplier_id => l_supplier_id

Line 892: --get the allocated but unconsumed rcv_transactions

888: ,p_project_id => l_project_id
889: ,p_task_id => l_task_id
890: ,x_need_to_find_pri_qty => l_onhand_quantity);
891:
892: --get the allocated but unconsumed rcv_transactions
893: IF l_onhand_quantity > 0
894: THEN
895: get_unconsumed_components(p_sub_po_unconsumed_row_type => p_sub_po_unconsumed_row_type
896: ,p_rep_po_unconsumed_row_type => p_rep_po_unconsumed_row_type

Line 923: -- the found onhand quantity has no matched rcv_transactions

919: AND ((task_id IS NULL) OR (task_id = l_task_id));
920:
921: IF l_onhand_quantity > 0
922: THEN
923: -- the found onhand quantity has no matched rcv_transactions
924: -- **** for debug information in readonly UT environment.--- begin ****
925: JMF_SHIKYU_RPT_UTIL.debug_output
926: (
927: p_output_to => 'FND_LOG.STRING'

Line 929: ,p_message => '** onhand quantity :' || l_onhand_quantity ||', has no matched rcv_transactions'

925: JMF_SHIKYU_RPT_UTIL.debug_output
926: (
927: p_output_to => 'FND_LOG.STRING'
928: ,p_api_name => G_MODULE_PREFIX || l_api_name
929: ,p_message => '** onhand quantity :' || l_onhand_quantity ||', has no matched rcv_transactions'
930: );
931: -- **** for debug information in readonly UT environment.--- end ****
932: END IF;
933:

Line 1024: ,rcv_transactions rt

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
1027: --Added to fix bug 5509464 end
1028: WHERE mid.row_type = p_rep_po_unalloc_row_type

Line 1039: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor

1035: AND pha.po_header_id=pll.po_header_id
1036: --Added to fix bug 5509464 end
1037: ORDER BY rt.transaction_date;
1038:
1039: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor
1040: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor
1041: --Added to fix bug 5509464 start
1042: l_supplier_id po_headers_all.vendor_id%TYPE; --for cursor
1043: l_supplier_site_id po_headers_all.vendor_site_id%TYPE; --for cursor

Line 1040: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor

1036: --Added to fix bug 5509464 end
1037: ORDER BY rt.transaction_date;
1038:
1039: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor
1040: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor
1041: --Added to fix bug 5509464 start
1042: l_supplier_id po_headers_all.vendor_id%TYPE; --for cursor
1043: l_supplier_site_id po_headers_all.vendor_site_id%TYPE; --for cursor
1044: --Added to fix bug 5509464 end

Line 1046: l_rep_po_residual_pri rcv_transactions.primary_quantity%TYPE;

1042: l_supplier_id po_headers_all.vendor_id%TYPE; --for cursor
1043: l_supplier_site_id po_headers_all.vendor_site_id%TYPE; --for cursor
1044: --Added to fix bug 5509464 end
1045:
1046: l_rep_po_residual_pri rcv_transactions.primary_quantity%TYPE;
1047: l_rcv_unallocated_pri rcv_transactions.primary_quantity%TYPE;
1048:
1049: BEGIN
1050: IF g_fnd_debug = 'Y' AND

Line 1047: l_rcv_unallocated_pri rcv_transactions.primary_quantity%TYPE;

1043: l_supplier_site_id po_headers_all.vendor_site_id%TYPE; --for cursor
1044: --Added to fix bug 5509464 end
1045:
1046: l_rep_po_residual_pri rcv_transactions.primary_quantity%TYPE;
1047: l_rcv_unallocated_pri rcv_transactions.primary_quantity%TYPE;
1048:
1049: BEGIN
1050: IF g_fnd_debug = 'Y' AND
1051: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 1133: --the possilbe unallocated rcv_transactions primary quantity

1129: ,p_task_id => p_task_id); --the quantity for primary uom
1130:
1131: IF l_rep_po_residual_pri > 0
1132: THEN
1133: --the possilbe unallocated rcv_transactions primary quantity
1134: l_rcv_unallocated_pri := jmf_shikyu_rpt_util.get_min3(p_number1 => l_rcv_unprocessed_primary_qty
1135: ,p_number2 => l_rep_po_residual_pri
1136: ,p_number3 => x_need_to_find_pri_qty);
1137:

Line 1475: l_rep_po_unallocated_pri rcv_transactions.primary_quantity%TYPE;

1471: ,p_task_id IN NUMBER
1472: ) RETURN NUMBER IS
1473: l_api_name CONSTANT VARCHAR2(30) := 'get_rep_po_residual_unalloc';
1474:
1475: l_rep_po_unallocated_pri rcv_transactions.primary_quantity%TYPE;
1476: BEGIN
1477: -- **** for debug information in readonly UT environment.--- begin ****
1478: JMF_SHIKYU_RPT_UTIL.debug_output
1479: (

Line 1510: ,rcv_transactions rcv

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
1513: AND cfr_mid.shikyu_id = poloc.line_location_id
1514: AND rcv.transaction_id = P_rcv_transaction_id

Line 1651: FROM rcv_transactions rcv

1647: AND tp_inv_org_id = p_tp_inv_org_id
1648: AND item_id = p_item_id
1649: AND shikyu_id =
1650: (SELECT rcv.po_line_location_id
1651: FROM rcv_transactions rcv
1652: WHERE rcv.transaction_id = p_rcv_transaction_id
1653: AND rcv.transaction_type = 'RECEIVE');
1654:
1655: /*

Line 1888: ,rcv_transactions rt

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
1892: AND mid.shikyu_id = alloc.subcontract_po_shipment_id

Line 1904: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor

1900: AND jsr.tp_supplier_site_id = p_supplier_site_id
1901: AND jsr.shikyu_component_id = p_item_id
1902: ORDER BY rt.transaction_date;
1903:
1904: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor
1905: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor
1906:
1907: l_sub_po_residual_pri rcv_transactions.primary_quantity%TYPE;
1908: l_rcv_unconsumed_pri rcv_transactions.primary_quantity%TYPE;

Line 1905: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor

1901: AND jsr.shikyu_component_id = p_item_id
1902: ORDER BY rt.transaction_date;
1903:
1904: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor
1905: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor
1906:
1907: l_sub_po_residual_pri rcv_transactions.primary_quantity%TYPE;
1908: l_rcv_unconsumed_pri rcv_transactions.primary_quantity%TYPE;
1909:

Line 1907: l_sub_po_residual_pri rcv_transactions.primary_quantity%TYPE;

1903:
1904: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor
1905: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor
1906:
1907: l_sub_po_residual_pri rcv_transactions.primary_quantity%TYPE;
1908: l_rcv_unconsumed_pri rcv_transactions.primary_quantity%TYPE;
1909:
1910: BEGIN
1911: -- **** for debug information in readonly UT environment.--- begin ****

Line 1908: l_rcv_unconsumed_pri rcv_transactions.primary_quantity%TYPE;

1904: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor
1905: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor
1906:
1907: l_sub_po_residual_pri rcv_transactions.primary_quantity%TYPE;
1908: l_rcv_unconsumed_pri rcv_transactions.primary_quantity%TYPE;
1909:
1910: BEGIN
1911: -- **** for debug information in readonly UT environment.--- begin ****
1912: JMF_SHIKYU_RPT_UTIL.debug_output

Line 1989: --the possilbe unconsumed rcv_transactions primary quantity

1985: ,p_task_id => p_task_id); --the quantity for primary uom
1986:
1987: IF l_sub_po_residual_pri > 0
1988: THEN
1989: --the possilbe unconsumed rcv_transactions primary quantity
1990: l_rcv_unconsumed_pri := jmf_shikyu_rpt_util.get_min3(p_number1 => l_rcv_unprocessed_primary_qty
1991: ,p_number2 => l_sub_po_residual_pri
1992: ,p_number3 => x_need_to_find_pri_qty);
1993:

Line 2460: l_sub_po_residual_pri rcv_transactions.primary_quantity%TYPE;

2456: ,p_task_id IN NUMBER
2457: ) RETURN NUMBER IS
2458: l_api_name CONSTANT VARCHAR2(30) := 'get_sub_po_residual_unconsume';
2459:
2460: l_sub_po_residual_pri rcv_transactions.primary_quantity%TYPE;
2461: BEGIN
2462: -- **** for debug information in readonly UT environment.--- begin ****
2463: JMF_SHIKYU_RPT_UTIL.debug_output
2464: (

Line 2495: ,rcv_transactions rcv

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
2499: AND rcv.transaction_type = 'RECEIVE'

Line 2582: ,rcv_transactions rcv

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
2586: AND rcv.transaction_type = 'RECEIVE'

Line 2897: FROM rcv_transactions rt

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)
2900: ,jscmt.primary_uom = (SELECT rt.primary_unit_of_measure
2901: FROM rcv_transactions rt

Line 2901: FROM rcv_transactions rt

2897: FROM rcv_transactions rt
2898: WHERE jscmt.row_type = CFR_TMP_RCV_ROW
2899: AND rt.transaction_id = jscmt.shikyu_id)
2900: ,jscmt.primary_uom = (SELECT rt.primary_unit_of_measure
2901: FROM rcv_transactions rt
2902: WHERE jscmt.row_type = CFR_TMP_RCV_ROW
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

Line 3283: ,rcv_transactions rcv

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
3285: ,mtl_parameters mp_tp
3286: ,po_vendors pv
3287: ,po_vendor_sites_all pvs

Line 3761: ,rcv_transactions rt

3757: ,po_lines_all pla_s
3758: ,po_releases_all pra_s
3759: ,wip_requirement_operations wro
3760: ,MTL_SYSTEM_ITEMS_B_KFV msibk
3761: ,rcv_transactions rt
3762: --Added to get task start
3763: ,pa_tasks task
3764: --Added to get task end
3765: WHERE jsc.SHIKYU_COMPONENT_ID = cfr_mid_item_group.item_id