APPS.ONT_OEXOECOD_XMLP_PKG dependencies on OE_DELIVER_TO_ORGS_V

Line 1440: OE_DELIVER_TO_ORGS_V L

1436: SELECT
1437: L.ADDRESS_LINE_1
1438: INTO L_ADDRESS1
1439: FROM
1440: OE_DELIVER_TO_ORGS_V L
1441: WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;
1442: RETURN (L_ADDRESS1);
1443: ELSIF IB_CURRENT_LOCATION = 'SOLD_TO' THEN
1444: SELECT

Line 1508: OE_DELIVER_TO_ORGS_V L

1504: L.POSTAL_CODE,
1505: L.COUNTRY
1506: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1507: FROM
1508: OE_DELIVER_TO_ORGS_V L
1509: WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;
1510: SELECT
1511: DECODE(L_CITY
1512: ,NULL

Line 1626: OE_DELIVER_TO_ORGS_V L

1622: SELECT
1623: L.ADDRESS_LINE_1
1624: INTO L_ADDRESS1
1625: FROM
1626: OE_DELIVER_TO_ORGS_V L
1627: WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;
1628: RETURN (L_ADDRESS1);
1629: ELSIF IB_INSTALLED_AT_LOCATION = 'SOLD_TO' THEN
1630: SELECT

Line 1694: OE_DELIVER_TO_ORGS_V L

1690: L.POSTAL_CODE,
1691: L.COUNTRY
1692: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1693: FROM
1694: OE_DELIVER_TO_ORGS_V L
1695: WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;
1696: SELECT
1697: DECODE(L_CITY
1698: ,NULL