eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE_HEADER dependencies on HZ_CUST_SITE_USES_ALL

Line 975: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

971: l_bill_to_party_id hz_cust_accounts.party_id%type;
972: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
973: l_org_id NUMBER;
974:
975: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
976: SELECT cust_acct.cust_account_id,
977: cust_Acct.party_id,
978: acct_site.party_site_id,
979: site_use.org_id

Line 981: HZ_CUST_SITE_USES_ALL site_use,

977: cust_Acct.party_id,
978: acct_site.party_site_id,
979: site_use.org_id
980: FROM
981: HZ_CUST_SITE_USES_ALL site_use,
982: HZ_CUST_ACCT_SITES_ALL acct_site,
983: HZ_CUST_ACCOUNTS_ALL cust_Acct
984: WHERE site_use.site_use_id = p_site_org_id
985: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1680: FROM HZ_CUST_SITE_USES_ALL SITE,

1676: --variable added for bug 3739650
1677: l_site_use_code := 'SHIP_TO' ;
1678: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1679: Into l_dummy
1680: FROM HZ_CUST_SITE_USES_ALL SITE,
1681: HZ_CUST_ACCT_SITES ACCT_SITE
1682: WHERE SITE.SITE_USE_ID = p_header_rec.ship_to_org_id
1683: AND SITE.SITE_USE_CODE = l_site_use_code
1684: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1776: FROM HZ_CUST_SITE_USES_ALL SITE,

1772: --variable added for bug 3739650
1773: l_site_use_code := 'DELIVER_TO' ;
1774: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1775: Into l_dummy
1776: FROM HZ_CUST_SITE_USES_ALL SITE,
1777: HZ_CUST_ACCT_SITES ACCT_SITE
1778: WHERE SITE.SITE_USE_ID = p_header_rec.deliver_to_org_id
1779: AND SITE.SITE_USE_CODE = l_site_use_code
1780: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1873: FROM HZ_CUST_SITE_USES_ALL SITE,

1869: --variable added for bug 3739650
1870: l_site_use_code := 'BILL_TO' ;
1871: SELECT 'VALID'
1872: Into l_dummy
1873: FROM HZ_CUST_SITE_USES_ALL SITE,
1874: HZ_CUST_ACCT_SITES ACCT_SITE
1875: WHERE SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id
1876: AND SITE.SITE_USE_CODE = l_site_use_code
1877: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1936: HZ_CUST_SITE_USES_ALL SITE,

1932:
1933: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1934: INTO l_dummy
1935: FROM
1936: HZ_CUST_SITE_USES_ALL SITE,
1937: HZ_CUST_ACCT_SITES ACCT_SITE
1938: WHERE
1939: SITE.SITE_USE_ID = p_header_rec.sold_to_site_use_id
1940: AND SITE.SITE_USE_CODE = 'SOLD_TO'

Line 2042: hz_cust_site_uses_all site_use,

2038: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2039: INTO
2040: l_dummy
2041: FROM
2042: hz_cust_site_uses_all site_use,
2043: hz_cust_acct_sites acct_site
2044: WHERE
2045: site_use.site_use_id=p_header_rec.end_customer_site_use_id
2046: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id

Line 2143: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650

2139: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2140: INTO l_dummy
2141: FROM
2142: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2143: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
2144: HZ_CUST_ACCT_SITES ADDR
2145: WHERE
2146: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id
2147: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

Line 2202: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650

2198: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2199: INTO l_dummy
2200: FROM
2201: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2202: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
2203: HZ_CUST_ACCT_SITES ADDR
2204: WHERE
2205: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id
2206: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

Line 2262: HZ_CUST_SITE_USES_ALL SITE_USE, --changed DELIVER to SITE_USE for bug 3739650

2258: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2259: INTO l_dummy
2260: FROM
2261: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2262: HZ_CUST_SITE_USES_ALL SITE_USE, --changed DELIVER to SITE_USE for bug 3739650
2263: HZ_CUST_ACCT_SITES ADDR
2264: WHERE
2265: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id
2266: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID