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 944: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

940: l_bill_to_party_id hz_cust_accounts.party_id%type;
941: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
942: l_org_id NUMBER;
943:
944: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
945: SELECT cust_acct.cust_account_id,
946: cust_Acct.party_id,
947: acct_site.party_site_id,
948: site_use.org_id

Line 950: HZ_CUST_SITE_USES_ALL site_use,

946: cust_Acct.party_id,
947: acct_site.party_site_id,
948: site_use.org_id
949: FROM
950: HZ_CUST_SITE_USES_ALL site_use,
951: HZ_CUST_ACCT_SITES_ALL acct_site,
952: HZ_CUST_ACCOUNTS_ALL cust_Acct
953: WHERE site_use.site_use_id = p_site_org_id
954: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1612: FROM HZ_CUST_SITE_USES_ALL SITE,

1608: --variable added for bug 3739650
1609: l_site_use_code := 'SHIP_TO' ;
1610: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1611: Into l_dummy
1612: FROM HZ_CUST_SITE_USES_ALL SITE,
1613: HZ_CUST_ACCT_SITES ACCT_SITE
1614: WHERE SITE.SITE_USE_ID = p_header_rec.ship_to_org_id
1615: AND SITE.SITE_USE_CODE = l_site_use_code
1616: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1708: FROM HZ_CUST_SITE_USES_ALL SITE,

1704: --variable added for bug 3739650
1705: l_site_use_code := 'DELIVER_TO' ;
1706: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1707: Into l_dummy
1708: FROM HZ_CUST_SITE_USES_ALL SITE,
1709: HZ_CUST_ACCT_SITES ACCT_SITE
1710: WHERE SITE.SITE_USE_ID = p_header_rec.deliver_to_org_id
1711: AND SITE.SITE_USE_CODE = l_site_use_code
1712: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1805: FROM HZ_CUST_SITE_USES_ALL SITE,

1801: --variable added for bug 3739650
1802: l_site_use_code := 'BILL_TO' ;
1803: SELECT 'VALID'
1804: Into l_dummy
1805: FROM HZ_CUST_SITE_USES_ALL SITE,
1806: HZ_CUST_ACCT_SITES ACCT_SITE
1807: WHERE SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id
1808: AND SITE.SITE_USE_CODE = l_site_use_code
1809: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1867: HZ_CUST_SITE_USES_ALL SITE,

1863:
1864: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1865: INTO l_dummy
1866: FROM
1867: HZ_CUST_SITE_USES_ALL SITE,
1868: HZ_CUST_ACCT_SITES ACCT_SITE
1869: WHERE
1870: SITE.SITE_USE_ID = p_header_rec.sold_to_site_use_id
1871: AND SITE.SITE_USE_CODE = 'SOLD_TO'

Line 1973: hz_cust_site_uses_all site_use,

1969: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1970: INTO
1971: l_dummy
1972: FROM
1973: hz_cust_site_uses_all site_use,
1974: hz_cust_acct_sites acct_site
1975: WHERE
1976: site_use.site_use_id=p_header_rec.end_customer_site_use_id
1977: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id

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

2070: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2071: INTO l_dummy
2072: FROM
2073: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2074: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
2075: HZ_CUST_ACCT_SITES ADDR
2076: WHERE
2077: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id
2078: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

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

2129: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2130: INTO l_dummy
2131: FROM
2132: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2133: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
2134: HZ_CUST_ACCT_SITES ADDR
2135: WHERE
2136: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id
2137: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

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

2189: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2190: INTO l_dummy
2191: FROM
2192: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2193: HZ_CUST_SITE_USES_ALL SITE_USE, --changed DELIVER to SITE_USE for bug 3739650
2194: HZ_CUST_ACCT_SITES ADDR
2195: WHERE
2196: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id
2197: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID