DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on MTL_INTERORG_PARAMETERS

Line 1554: FROM mtl_interorg_parameters

1550: SELECT fob_point
1551: , intransit_inv_account
1552: INTO l_fob_point
1553: , l_intransit_inv_account
1554: FROM mtl_interorg_parameters
1555: WHERE from_organization_id = v_mmtt.organization_id
1556: AND to_organization_id = v_mmtt.transfer_organization;
1557: EXCEPTION
1558: WHEN NO_DATA_FOUND THEN

Line 1606: int mtl_interorg parameters*/

1602: corner case.
1603: In case rcv record does not have the reference to the
1604: correspoding shipment transaction, we shoudl populate the
1605: rcpt transaction with the fob_point by running a fresh query
1606: int mtl_interorg parameters*/
1607: BEGIN
1608: SELECT fob_point
1609: , intransit_inv_account
1610: INTO l_fob_point

Line 1612: FROM mtl_interorg_parameters

1608: SELECT fob_point
1609: , intransit_inv_account
1610: INTO l_fob_point
1611: , l_intransit_inv_account
1612: FROM mtl_interorg_parameters
1613: WHERE from_organization_id = v_mmtt.transfer_organization
1614: AND to_organization_id = v_mmtt.organization_id;
1615: EXCEPTION
1616: WHEN NO_DATA_FOUND THEN