APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on MTL_INTERORG_PARAMETERS

Line 974: FROM MTL_INTERORG_PARAMETERS mip

970: DECODE(fob_point,1,to_organization_id,
971: 2,from_organization_id) owning_organization_id,
972: 21 transaction_action_id, -- intransit shipment
973: fob_point
974: FROM MTL_INTERORG_PARAMETERS mip
975: WHERE NVL(fob_point,-1) in (1,2)
976: UNION ALL
977: SELECT /*+ parallel(mip) */
978: to_organization_id,

Line 984: FROM MTL_INTERORG_PARAMETERS mip

980: DECODE(fob_point,1,to_organization_id,
981: 2,from_organization_id) owning_organization_id,
982: 12 transaction_action_id, -- intransit receipt
983: fob_point
984: FROM MTL_INTERORG_PARAMETERS mip
985: WHERE NVL(fob_point,-1) in (1,2)) mip_outer
986: WHERE mip_outer.owning_organization_id =mp.organization_id
987: ;
988:

Line 1550: -- mip has two records for each setup in mtl_interorg_parameters.

1546: -- value.
1547: -- This extract gets only discrete intransit data.
1548:
1549: -- Explaination of data stored in MIP:
1550: -- mip has two records for each setup in mtl_interorg_parameters.
1551: -- e.g. for M1 -> M2 FOB = 2 there are two records in mip
1552:
1553: -- from_org to_org owning_org txn_action_id
1554: -- M1 M2 M1 21(shipment)