DBA Data[Home] [Help]

APPS.INV_MGD_MVT_SO_MDTR dependencies on MTL_PARAMETERS

Line 79: --again in mtl_parameters or hr_all_organization_units as OOD does

75: --Fix perf bug 4912552, use hr_organization_information to replace
76: --org_organization_definitions according to proposal from INV
77: --karthik.gnanamurthy, because inventory organization is already existing
78: --in rcv_transactions, so it's not required to validate the organization
79: --again in mtl_parameters or hr_all_organization_units as OOD does
80: IF NVL(p_movement_transaction.creation_method,'A') = 'A'
81: THEN
82: IF NVL(p_movement_transaction.document_source_type,'SO') = 'IO'
83: THEN

Line 627: , MTL_PARAMETERS MP

623: l_shipment_transaction.org_id
624: FROM
625: HR_ORGANIZATION_INFORMATION HOI1
626: , HR_ORGANIZATION_INFORMATION HOI2
627: , MTL_PARAMETERS MP
628: WHERE MP.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
629: AND MP.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
630: AND HOI1.ORG_INFORMATION1 = 'INV'
631: AND HOI1.ORG_INFORMATION2 = 'Y'