APPS.WIP_FLOW_VALIDATION dependencies on MTL_PARAMETERS

Line 69: mrp_project_parameters mpp, mtl_parameters mp

65: or( mti.source_project_id is not null
66: and exists (
67: select 'class is valid'
68: from cst_cg_wip_acct_classes_v cwac,
69: mrp_project_parameters mpp, mtl_parameters mp
70: where cwac.class_code = mti.accounting_class
71: and cwac.class_type = 1
72: and mpp.project_id = mti.source_project_id
73: and mpp.organization_id = mti.organization_id

Line 885: from mtl_parameters mps

881: where rowid = p_rowid
882: and ( ( source_project_id is not null
883: and exists (
884: select 1
885: from mtl_parameters mps
886: where nvl(mps.project_reference_enabled,2) = 1
887: and mps.organization_id = mti.organization_id
888: )
889: and exists (

Line 941: mtl_parameters mps

937: ***************************************************/
938:
939: select 1 into x_success
940: from mtl_transactions_interface mti,
941: mtl_parameters mps
942: where mti.rowid = p_rowid
943: and mps.organization_id = mti.organization_id
944: and ( ( nvl(mps.project_control_level,1) = 2
945: and ( ( mti.source_project_id is not null

Line 1107: FROM pjm_unit_numbers_lov_v N, mtl_parameters P

1103: OR (end_item_unit_number IS NOT NULL
1104: AND (pjm_unit_eff.enabled = 'Y'
1105: AND pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'Y'
1106: AND end_item_unit_number IN (SELECT unit_number
1107: FROM pjm_unit_numbers_lov_v N, mtl_parameters P
1108: WHERE P.organization_id = mti.organization_id and
1109: P.master_organization_id = N.master_organization_id)
1110: AND (mti.scheduled_flag <> 1
1111: OR exists (SELECT 1