APPS.GMF_LOT_COSTING_PUB dependencies on MTL_PARAMETERS

Line 839: mtl_parameters mp,

835: mtl_material_transactions mmt,
836: gme_batch_step_items gbsi,
837: gme_material_details gmd,
838: mtl_transaction_lot_numbers mtln,
839: mtl_parameters mp,
840: hr_organization_information hoi,
841: gme_transaction_pairs gtp
842: WHERE gbsi.batch_id = p_batch_id
843: AND gbsi.batchstep_id = p_batchstep_id

Line 903: mtl_parameters mp,

899: FROM mtl_system_items_b iimb,
900: mtl_material_transactions mmt,
901: gme_material_details gmd,
902: mtl_transaction_lot_numbers mtln,
903: mtl_parameters mp,
904: hr_organization_information hoi
905: WHERE mmt.transaction_source_type_id = 5
906: AND gmd.line_type IN (-1,2)
907: AND mtln.transaction_quantity <> 0

Line 1121: FROM cm_whse_asc cstw, mtl_parameters invw

1117: AND gps.start_date <= p_date
1118: AND gps.end_date >= p_date
1119: AND gps.period_id = cst.period_id
1120: AND cst.organization_id = (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1121: FROM cm_whse_asc cstw, mtl_parameters invw
1122: WHERE cstw.organization_id(+) = invw.organization_id
1123: AND invw.organization_id = p_orgn_id
1124: AND NVL(cstw.eff_start_date,p_date) <= p_date
1125: AND NVL(cstw.eff_end_date,p_date) >= p_date

Line 1158: FROM cm_whse_asc cstw, mtl_parameters invw

1154: AND cst.cost_type_id = p_cost_type_id
1155: AND gps.period_id = cst.period_id
1156: AND cst.organization_id =
1157: (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1158: FROM cm_whse_asc cstw, mtl_parameters invw
1159: WHERE cstw.organization_id(+) = invw.organization_id
1160: AND invw.organization_id = p_orgn_id
1161: AND NVL(cstw.eff_start_date,p_date) <= p_date
1162: AND NVL(cstw.eff_end_date,p_date) >= p_date

Line 7238: FROM mtl_parameters mp

7234: /*
7235: IF (p_orgn_id IS NOT NULL) THEN
7236: SELECT mp.organization_code
7237: INTO l_from_orgn_code
7238: FROM mtl_parameters mp
7239: WHERE mp.organization_id = p_orgn_id;
7240: END IF;
7241: */
7242: l_le_id := p_le_id;

Line 7264: FROM mtl_parameters mp,

7260: operating_unit_id
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

Line 9051: FROM mtl_parameters mp

9047: )
9048: THEN
9049: SELECT decode(mp.process_enabled_flag,'N',1,0)
9050: INTO l_flg_ind
9051: FROM mtl_parameters mp
9052: WHERE mp.organization_id = transaction_row.transfer_orgn_id;
9053:
9054: IF (l_flg_ind = 0) THEN
9055: process_receipt;

Line 9172: FROM mtl_parameters mp

9168: */
9169:
9170: SELECT decode(mp.process_enabled_flag,'N',1,0)
9171: INTO l_flg_ind
9172: FROM mtl_parameters mp
9173: WHERE mp.organization_id = transaction_row.transfer_orgn_id;
9174:
9175: IF (l_flg_ind = 0) THEN
9176: process_movement( transaction_row.line_type