APPS.ONT_OEXOECOD_XMLP_PKG dependencies on OE_DELIVER_TO_ORGS_V

Line 1444: OE_DELIVER_TO_ORGS_V L

1440: SELECT
1441: L.ADDRESS_LINE_1
1442: INTO L_ADDRESS1
1443: FROM
1444: OE_DELIVER_TO_ORGS_V L
1445: WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;
1446: RETURN (L_ADDRESS1);
1447: ELSIF IB_CURRENT_LOCATION = 'SOLD_TO' THEN
1448: SELECT

Line 1512: OE_DELIVER_TO_ORGS_V L

1508: L.POSTAL_CODE,
1509: L.COUNTRY
1510: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1511: FROM
1512: OE_DELIVER_TO_ORGS_V L
1513: WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;
1514: SELECT
1515: DECODE(L_CITY
1516: ,NULL

Line 1630: OE_DELIVER_TO_ORGS_V L

1626: SELECT
1627: L.ADDRESS_LINE_1
1628: INTO L_ADDRESS1
1629: FROM
1630: OE_DELIVER_TO_ORGS_V L
1631: WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;
1632: RETURN (L_ADDRESS1);
1633: ELSIF IB_INSTALLED_AT_LOCATION = 'SOLD_TO' THEN
1634: SELECT

Line 1698: OE_DELIVER_TO_ORGS_V L

1694: L.POSTAL_CODE,
1695: L.COUNTRY
1696: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1697: FROM
1698: OE_DELIVER_TO_ORGS_V L
1699: WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;
1700: SELECT
1701: DECODE(L_CITY
1702: ,NULL