DBA Data[Home] [Help]

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 884: from mtl_parameters mps

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

Line 940: mtl_parameters mps

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

Line 1106: FROM pjm_unit_numbers_lov_v N, mtl_parameters P

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