1730: l_id NUMBER;
1731:
1732: CURSOR c_ship_to_org_id IS
1733: SELECT ORGANIZATION_ID
1734: FROM OE_SHIP_TO_ORGS_V
1735: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1736: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1737: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1738: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1772: ELSE
1773:
1774: SELECT ORGANIZATION_ID
1775: INTO l_id
1776: FROM OE_SHIP_TO_ORGS_V
1777: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1778: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1779: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1780: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1850:
1851:
1852: CURSOR c_ship_to_org_id IS
1853: SELECT ORGANIZATION_ID
1854: FROM OE_SHIP_TO_ORGS_V
1855: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1856: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1857: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1858: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1871: AND CUSTOMER_ID = p_sold_to_org_id;
1872:
1873: CURSOR C1 IS
1874: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1875: FROM OE_SHIP_TO_ORGS_V
1876: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1877: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1878: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1879: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1898: and ship_to_flag = 'Y');
1899:
1900: CURSOR C2 IS
1901: SELECT ORGANIZATION_ID
1902: FROM OE_SHIP_TO_ORGS_V
1903: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1904: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1905: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1906: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1940: ELSE
1941:
1942: SELECT ORGANIZATION_ID
1943: INTO l_id
1944: FROM OE_SHIP_TO_ORGS_V
1945: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1946: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1947: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1948: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
1969: ELSE
1970:
1971: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1972: INTO l_id
1973: FROM OE_SHIP_TO_ORGS_V
1974: WHERE ADDRESS_LINE_1 = p_ship_to_address1
1975: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1976: nvl( p_ship_to_address2, fnd_api.g_miss_char)
1977: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
2006: ELSE
2007:
2008: SELECT ORGANIZATION_ID
2009: INTO l_id
2010: FROM OE_SHIP_TO_ORGS_V
2011: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2012: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2013: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2014: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =