DBA Data[Home] [Help]

APPS.CST_DIAGNOSTICS_PKG dependencies on MTL_INTERORG_PARAMETERS

Line 187: from mtl_interorg_parameters MIP

183: )
184: OR
185: (
186: exists (select null
187: from mtl_interorg_parameters MIP
188: where transaction_action_id = 12
189: AND MIP.to_organization_id = MMT.organization_id
190: AND MIP.from_organization_id = MMT.transfer_organization_id
191: AND NVL(MMT.fob_point,MIP.fob_point) = 2

Line 207: from mtl_interorg_parameters MIP

203: AND costed_flag = 'N'
204: AND
205: (
206: exists (select null
207: from mtl_interorg_parameters MIP
208: where transaction_action_id = 21
209: AND MIP.to_organization_id = MMT.transfer_organization_id
210: AND MIP.from_organization_id = MMT.organization_id
211: AND NVL(MMT.fob_point,MIP.fob_point) = 1

Line 243: from mtl_interorg_parameters MIP

239: (
240: costed_flag = 'N'
241: AND
242: exists (select null
243: from mtl_interorg_parameters MIP
244: where
245: (
246: transaction_action_id = 21
247: AND MIP.to_organization_id = MMT.transfer_organization_id

Line 341: from mtl_interorg_parameters MIP

337: OR
338: (
339: exists (
340: select null
341: from mtl_interorg_parameters MIP
342: where transaction_action_id = 12
343: AND MIP.to_organization_id = MMT.organization_id
344: AND MIP.from_organization_id = MMT.transfer_organization_id
345: AND NVL(MMT.fob_point,MIP.fob_point) = 2

Line 362: from mtl_interorg_parameters MIP

358: AND
359: (
360: exists (
361: select null
362: from mtl_interorg_parameters MIP
363: where transaction_action_id = 21
364: AND MIP.to_organization_id = MMT.transfer_organization_id
365: AND MIP.from_organization_id = MMT.organization_id
366: AND NVL(MMT.fob_point,MIP.fob_point) = 1

Line 399: from mtl_interorg_parameters MIP

395: costed_flag = 'N'
396: AND
397: exists (
398: select null
399: from mtl_interorg_parameters MIP
400: where
401: (
402: transaction_action_id = 21
403: AND MIP.to_organization_id = MMT.transfer_organization_id