DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on MTL_INTERORG_PARAMETERS

Line 1337: FROM mtl_interorg_parameters

1333: SELECT fob_point
1334: , intransit_inv_account
1335: INTO l_fob_point
1336: , l_intransit_inv_account
1337: FROM mtl_interorg_parameters
1338: WHERE from_organization_id = v_mmtt.organization_id
1339: AND to_organization_id = v_mmtt.transfer_organization;
1340: EXCEPTION
1341: WHEN NO_DATA_FOUND THEN

Line 1389: int mtl_interorg parameters*/

1385: corner case.
1386: In case rcv record does not have the reference to the
1387: correspoding shipment transaction, we shoudl populate the
1388: rcpt transaction with the fob_point by running a fresh query
1389: int mtl_interorg parameters*/
1390: BEGIN
1391: SELECT fob_point
1392: , intransit_inv_account
1393: INTO l_fob_point

Line 1395: FROM mtl_interorg_parameters

1391: SELECT fob_point
1392: , intransit_inv_account
1393: INTO l_fob_point
1394: , l_intransit_inv_account
1395: FROM mtl_interorg_parameters
1396: WHERE from_organization_id = v_mmtt.transfer_organization
1397: AND to_organization_id = v_mmtt.organization_id;
1398: EXCEPTION
1399: WHEN NO_DATA_FOUND THEN