APPS.GMF_LOT_COSTING_PUB dependencies on GMF_FISCAL_POLICIES

Line 1561: FROM gmf_fiscal_policies d

1557: AND (mic.organization_id = p_orgn_id OR p_orgn_id IS NULL)
1558: )
1559: UNION
1560: SELECT d.mtl_cmpntcls_id, d.mtl_analysis_code, 3
1561: FROM gmf_fiscal_policies d
1562: WHERE d.legal_entity_id = p_le_id
1563: ORDER BY 3;
1564:
1565: -- Cursor to retrieve item-specific and lot-specific burdens. If burdens are defined at

Line 3662: FROM gmf_fiscal_policies

3658: WHERE transaction_id = transaction_row.transaction_id;
3659:
3660: -- Bug 14392602 Use cost component set up at Item level before Fiscal policy
3661: /* SELECT mtl_cmpntcls_id, mtl_analysis_code INTO l_ccc_id, l_a_code
3662: FROM gmf_fiscal_policies
3663: WHERE legal_entity_id = p_target_le; */
3664:
3665: OPEN component_class_cursor
3666: (l_le_id, transaction_row.inventory_item_id, transaction_row.orgn_id,transaction_row.trans_date);

Line 3880: FROM gmf_fiscal_policies s,

3876: -- PK Bug Bug 9356358 / 12.1 Bug 9400419 this code is not required. Transfer_price in MMT is already in receiving org currency.
3877: /* IF p_source_le <> p_target_le THEN
3878: SELECT s.base_currency_code,t.base_currency_code
3879: INTO l_from_ccy_code, l_to_ccy_code
3880: FROM gmf_fiscal_policies s,
3881: gmf_fiscal_policies t
3882: WHERE s.legal_entity_id = p_source_le
3883: AND t.legal_entity_id = p_target_le;
3884:

Line 3881: gmf_fiscal_policies t

3877: /* IF p_source_le <> p_target_le THEN
3878: SELECT s.base_currency_code,t.base_currency_code
3879: INTO l_from_ccy_code, l_to_ccy_code
3880: FROM gmf_fiscal_policies s,
3881: gmf_fiscal_policies t
3882: WHERE s.legal_entity_id = p_source_le
3883: AND t.legal_entity_id = p_target_le;
3884:
3885: IF l_from_ccy_code <> l_to_ccy_code THEN

Line 8401: FROM GMF_FISCAL_POLICIES WHERE legal_entity_id = l_le_id ;

8397: /* B9131983 If cost is ZERO or component is not available
8398: select the default value from fiscal policy and use it in cost details */
8399: SELECT mtl_analysis_code, mtl_cmpntcls_id
8400: INTO x_mtl_analysis_code, x_mtl_cmpntcls_id
8401: FROM GMF_FISCAL_POLICIES WHERE legal_entity_id = l_le_id ;
8402:
8403: old_cost_tab.delete;
8404:
8405: OPEN lot_cost_cursor (transaction_row.orgn_id,

Line 9622: FROM gmf_fiscal_policies

9618: default_ovh_analysis_code,
9619: 0,
9620: p_trp_cost,
9621: 1
9622: FROM gmf_fiscal_policies
9623: WHERE legal_entity_id = p_le_id ;
9624: BEGIN
9625:
9626: procedure_name := 'process_pdtxf_cost';

Line 10122: FROM GMF_FISCAL_POLICIES

10118: /* INVCONV sschinch */
10119: -- Bug 13038249
10120: SELECT mtl_analysis_code, mtl_cmpntcls_id, base_currency_code
10121: INTO l_mtl_analysis_code, l_mtl_cmpntcls_id , l_base_ccy_code
10122: FROM GMF_FISCAL_POLICIES
10123: WHERE legal_entity_id = l_le_id ;
10124:
10125: fnd_file.put_line(fnd_file.log,'Fiscal Policy material component class = '||l_mtl_cmpntcls_id||' Analysis Code '||l_mtl_analysis_code);
10126: