APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on STANDARD

Line 51: --| 16-JAN-2006 shu using FND_LOG.STRING for logging standard |

47: --| warning if SHIKYU profile is disable |
48: --| 05-DEC-2005 shu Fixed some no data issue due to null columns |
49: --| 07-DEC-2005 shu added procedures rpt_get_xxx for report data |
50: --| 21-DEC-2005 shu tuning SQLperformance in get_onhand_components|
51: --| 16-JAN-2006 shu using FND_LOG.STRING for logging standard |
52: --| 19-JAN-2006 shu changed parameter p_currency_conversion_date |
53: --| from date to varchar2; |
54: --| added rpt_debug_show_mid_data procedure |
55: --| added rpt_debug_show_temp_data procedure |

Line 134: --| 16-NOV-2007 kdevadas Bug 6630087 - Removed the standard cost check|

130: --| subcontracting PO |
131: --| 04-OCT-2007 kdevadas 12.1 Buy/Sell Subcontracting changes |
132: --| Reference - GBL_BuySell_TDD.doc |
133: --| Reference - GBL_BuySell_FDD.doc |
134: --| 16-NOV-2007 kdevadas Bug 6630087 - Removed the standard cost check|
135: --| as Buy/Sell subcontracting supports non-std |
136: --| OEM orgs as well |
137: --+===========================================================================+
138:

Line 3019: --step1: get crude data: add the data for standard po, using po_lines_all

3015: );
3016: -- **** for debug information in readonly UT environment.--- end ****
3017:
3018:
3019: --step1: get crude data: add the data for standard po, using po_lines_all
3020: rpt_get_crude_data(p_rpt_mode => p_rpt_mode
3021: ,p_currency_conversion_type => p_currency_conversion_type
3022: ,p_currency_conversion_date => l_p_currency_conversion_date
3023: ,p_functional_currency => p_functional_currency);

Line 3233: ,0) value3 --Standard_Item_Cost in Pri UOM and Pri Currency

3229: PO_UOM_S.po_uom_convert_p(cfr_mid.uom
3230: ,cfr_mid.primary_uom
3231: ,cfr_mid.item_id)) value2 --the item price in Pri UOM and Pri Currency
3232: ,NVL(cic.item_cost
3233: ,0) value3 --Standard_Item_Cost in Pri UOM and Pri Currency
3234: --updated to fix project_id related issue start
3235: --,rcv.project_id project_id
3236: ,sub.project_id project_id
3237: --updated to fix project_id related issue start

Line 3339: /*Standard Cost check no longer required

3335: AND plla_s.po_release_id = pra_s.po_release_id(+)
3336: AND oola.inventory_item_id = cic.inventory_item_id(+)
3337: AND oola.ship_from_org_id = cic.organization_id(+);
3338: /* Bug 6630087 - Start */
3339: /*Standard Cost check no longer required
3340: as Buy/Sell Subcontracting is supported for non-standard cost
3341: OEM organizations as well.
3342: Note : The confirmation report will display data for both
3343: Chargeable Subcontracting and Buy/Sell enabled OEM orgs depending

Line 3340: as Buy/Sell Subcontracting is supported for non-standard cost

3336: AND oola.inventory_item_id = cic.inventory_item_id(+)
3337: AND oola.ship_from_org_id = cic.organization_id(+);
3338: /* Bug 6630087 - Start */
3339: /*Standard Cost check no longer required
3340: as Buy/Sell Subcontracting is supported for non-standard cost
3341: OEM organizations as well.
3342: Note : The confirmation report will display data for both
3343: Chargeable Subcontracting and Buy/Sell enabled OEM orgs depending
3344: on the parameters chosen in the report */

Line 3345: -- AND cic.cost_type_id = 1; --frozen cost/ standard cost

3341: OEM organizations as well.
3342: Note : The confirmation report will display data for both
3343: Chargeable Subcontracting and Buy/Sell enabled OEM orgs depending
3344: on the parameters chosen in the report */
3345: -- AND cic.cost_type_id = 1; --frozen cost/ standard cost
3346: /* Bug 6630087 - End */
3347:
3348: -- should insert the onhand items that without SubContracting Order.
3349: --or it will lose the onhand items