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_LINE dependencies on HZ_CUST_SITE_USES_ALL

Line 2305: FROM HZ_CUST_SITE_USES_ALL SITE,

2301: --variable added for bug 3739650
2302: l_site_use_code := 'SHIP_TO' ;
2303: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2304: Into l_dummy
2305: FROM HZ_CUST_SITE_USES_ALL SITE,
2306: HZ_CUST_ACCT_SITES ACCT_SITE
2307: WHERE SITE.SITE_USE_ID = p_ship_to_org_id
2308: AND SITE.SITE_USE_CODE = l_site_use_code
2309: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 2387: FROM HZ_CUST_SITE_USES_ALL SITE,

2383: --variable added for bug 3739650
2384: l_site_use_code := 'DELIVER_TO' ;
2385: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2386: Into l_dummy
2387: FROM HZ_CUST_SITE_USES_ALL SITE,
2388: HZ_CUST_ACCT_SITES ACCT_SITE
2389: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
2390: AND SITE.SITE_USE_CODE = l_site_use_code
2391: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 2524: from hz_cust_site_uses_all su,

2520: and bill_to_flag = 'Y'
2521: and h.org_id =ratrx.org_id
2522: union
2523: select cas.cust_account_id customer_id
2524: from hz_cust_site_uses_all su,
2525: hz_cust_acct_sites_all cas
2526: where cas.cust_acct_site_id = su.cust_acct_site_id
2527: and su.site_use_id = p_line_rec.invoice_to_org_id
2528: and cas.org_id=ratrx.org_id

Line 2532: hz_cust_site_uses_all su,

2528: and cas.org_id=ratrx.org_id
2529: union
2530: select c.cust_account_id customer_id
2531: from hz_cust_acct_relate_all c,
2532: hz_cust_site_uses_all su,
2533: hz_cust_acct_sites_all cas
2534: where cas.cust_acct_site_id = su.cust_acct_site_id
2535: and su.site_use_id = p_line_rec.invoice_to_org_id
2536: and c.related_cust_account_id = cas.cust_account_id

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

3784: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
3785: l_org_id NUMBER;
3786: -- l_legal_entity_id NUMBER;
3787:
3788: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
3789: SELECT cust_acct.cust_account_id,
3790: cust_Acct.party_id,
3791: acct_site.party_site_id,
3792: site_use.org_id

Line 3794: HZ_CUST_SITE_USES_ALL site_use,

3790: cust_Acct.party_id,
3791: acct_site.party_site_id,
3792: site_use.org_id
3793: FROM
3794: HZ_CUST_SITE_USES_ALL site_use,
3795: HZ_CUST_ACCT_SITES_ALL acct_site,
3796: HZ_CUST_ACCOUNTS_ALL cust_Acct
3797: WHERE site_use.site_use_id = p_site_org_id
3798: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

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

5334: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5335: INTO l_dummy
5336: FROM
5337: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5338: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
5339: HZ_CUST_ACCT_SITES ADDR
5340: WHERE
5341: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.ship_to_contact_id
5342: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

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

5428: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5429: INTO l_dummy
5430: FROM
5431: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5432: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5433: HZ_CUST_ACCT_SITES ADDR
5434: WHERE
5435: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.deliver_to_contact_id
5436: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

Line 5507: FROM HZ_CUST_SITE_USES_ALL SITE,

5503: --variable added for bug 3739650
5504: l_site_use_code := 'BILL_TO' ;
5505: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5506: Into l_dummy
5507: FROM HZ_CUST_SITE_USES_ALL SITE,
5508: HZ_CUST_ACCT_SITES ACCT_SITE
5509: WHERE SITE.SITE_USE_ID = p_line_rec.invoice_to_org_id
5510: AND SITE.SITE_USE_CODE = l_site_use_code
5511: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

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

5581: SELECT 'VALID'
5582: INTO l_dummy
5583: FROM
5584: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5585: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5586: HZ_CUST_ACCT_SITES_ALL ADDR
5587: WHERE
5588: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.invoice_to_contact_id
5589: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

Line 7319: hz_cust_site_uses_all site_use,

7315: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
7316: INTO
7317: l_dummy
7318: FROM
7319: hz_cust_site_uses_all site_use,
7320: hz_cust_acct_sites acct_site
7321: WHERE
7322: site_use.site_use_id=p_line_rec.end_customer_site_use_id
7323: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id