DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_FISCAL_POLICIES

Line 1255: FROM gmf_fiscal_policies d

1251: AND (mic.organization_id = p_orgn_id OR p_orgn_id IS NULL)
1252: )
1253: UNION
1254: SELECT d.mtl_cmpntcls_id, d.mtl_analysis_code, 3
1255: FROM gmf_fiscal_policies d
1256: WHERE d.legal_entity_id = p_le_id
1257: ORDER BY 3;
1258:
1259: -- Cursor to retrieve item-specific and lot-specific burdens. If burdens are defined at

Line 3246: FROM gmf_fiscal_policies s,

3242: IF p_source_le <> p_target_le
3243: THEN
3244: SELECT s.base_currency_code,t.base_currency_code
3245: INTO l_from_ccy_code, l_to_ccy_code
3246: FROM gmf_fiscal_policies s,
3247: gmf_fiscal_policies t
3248: WHERE s.legal_entity_id = p_source_le
3249: AND t.legal_entity_id = p_target_le;
3250:

Line 3247: gmf_fiscal_policies t

3243: THEN
3244: SELECT s.base_currency_code,t.base_currency_code
3245: INTO l_from_ccy_code, l_to_ccy_code
3246: FROM gmf_fiscal_policies s,
3247: gmf_fiscal_policies t
3248: WHERE s.legal_entity_id = p_source_le
3249: AND t.legal_entity_id = p_target_le;
3250:
3251: IF l_from_ccy_code <> l_to_ccy_code

Line 7265: gmf_fiscal_policies gfp,

7261: )
7262: SELECT mp.organization_id, mp.organization_code, gfp.base_currency_code,
7263: NULL, gfp.legal_entity_id, ood.operating_unit
7264: FROM mtl_parameters mp,
7265: gmf_fiscal_policies gfp,
7266: org_organization_definitions ood
7267: WHERE mp.process_enabled_flag = 'Y'
7268: AND gfp.legal_entity_id = ood.legal_entity
7269: AND mp.organization_id = ood.organization_id;

Line 8020: FROM gmf_fiscal_policies

8016: default_ovh_analysis_code,
8017: 0,
8018: p_trp_cost,
8019: 1
8020: FROM gmf_fiscal_policies
8021: WHERE legal_entity_id = p_le_id ;
8022: BEGIN
8023:
8024: procedure_name := 'process_pdtxf_cost';

Line 8471: FROM gmf_fiscal_policies

8467: the base currency and if not, convert it to the base currency */
8468: /* INVCONV sschinch */
8469: SELECT base_currency_code
8470: INTO l_base_ccy_code
8471: FROM gmf_fiscal_policies
8472: WHERE legal_entity_id = l_le_id;
8473:
8474:
8475: /******** Bug 4038722 - Dinesh Vadivel - End**********/