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 2430: FROM HZ_CUST_SITE_USES_ALL SITE,

2426: --variable added for bug 3739650
2427: l_site_use_code := 'SHIP_TO' ;
2428: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2429: Into l_dummy
2430: FROM HZ_CUST_SITE_USES_ALL SITE,
2431: HZ_CUST_ACCT_SITES ACCT_SITE
2432: WHERE SITE.SITE_USE_ID = p_ship_to_org_id
2433: AND SITE.SITE_USE_CODE = l_site_use_code
2434: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 2512: FROM HZ_CUST_SITE_USES_ALL SITE,

2508: --variable added for bug 3739650
2509: l_site_use_code := 'DELIVER_TO' ;
2510: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2511: Into l_dummy
2512: FROM HZ_CUST_SITE_USES_ALL SITE,
2513: HZ_CUST_ACCT_SITES ACCT_SITE
2514: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
2515: AND SITE.SITE_USE_CODE = l_site_use_code
2516: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 2649: from hz_cust_site_uses_all su,

2645: and bill_to_flag = 'Y'
2646: and h.org_id =ratrx.org_id
2647: union
2648: select cas.cust_account_id customer_id
2649: from hz_cust_site_uses_all su,
2650: hz_cust_acct_sites_all cas
2651: where cas.cust_acct_site_id = su.cust_acct_site_id
2652: and su.site_use_id = p_line_rec.invoice_to_org_id
2653: and cas.org_id=ratrx.org_id

Line 2657: hz_cust_site_uses_all su,

2653: and cas.org_id=ratrx.org_id
2654: union
2655: select c.cust_account_id customer_id
2656: from hz_cust_acct_relate_all c,
2657: hz_cust_site_uses_all su,
2658: hz_cust_acct_sites_all cas
2659: where cas.cust_acct_site_id = su.cust_acct_site_id
2660: and su.site_use_id = p_line_rec.invoice_to_org_id
2661: and c.related_cust_account_id = cas.cust_account_id

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

3916: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
3917: l_org_id NUMBER;
3918: -- l_legal_entity_id NUMBER;
3919:
3920: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
3921: SELECT cust_acct.cust_account_id,
3922: cust_Acct.party_id,
3923: acct_site.party_site_id,
3924: site_use.org_id

Line 3926: HZ_CUST_SITE_USES_ALL site_use,

3922: cust_Acct.party_id,
3923: acct_site.party_site_id,
3924: site_use.org_id
3925: FROM
3926: HZ_CUST_SITE_USES_ALL site_use,
3927: HZ_CUST_ACCT_SITES_ALL acct_site,
3928: HZ_CUST_ACCOUNTS_ALL cust_Acct
3929: WHERE site_use.site_use_id = p_site_org_id
3930: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

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

5675: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5676: INTO l_dummy
5677: FROM
5678: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5679: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
5680: HZ_CUST_ACCT_SITES ADDR
5681: WHERE
5682: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.ship_to_contact_id
5683: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

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

5769: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5770: INTO l_dummy
5771: FROM
5772: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5773: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5774: HZ_CUST_ACCT_SITES ADDR
5775: WHERE
5776: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.deliver_to_contact_id
5777: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

Line 5848: FROM HZ_CUST_SITE_USES_ALL SITE,

5844: --variable added for bug 3739650
5845: l_site_use_code := 'BILL_TO' ;
5846: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5847: Into l_dummy
5848: FROM HZ_CUST_SITE_USES_ALL SITE,
5849: HZ_CUST_ACCT_SITES ACCT_SITE
5850: WHERE SITE.SITE_USE_ID = p_line_rec.invoice_to_org_id
5851: AND SITE.SITE_USE_CODE = l_site_use_code
5852: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

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

5922: SELECT 'VALID'
5923: INTO l_dummy
5924: FROM
5925: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5926: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5927: HZ_CUST_ACCT_SITES_ALL ADDR
5928: WHERE
5929: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.invoice_to_contact_id
5930: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID

Line 7717: hz_cust_site_uses_all site_use,

7713: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
7714: INTO
7715: l_dummy
7716: FROM
7717: hz_cust_site_uses_all site_use,
7718: hz_cust_acct_sites acct_site
7719: WHERE
7720: site_use.site_use_id=p_line_rec.end_customer_site_use_id
7721: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id