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.ASO_MAP_QUOTE_ORDER_INT dependencies on HZ_ORG_CONTACTS

Line 2520: hz_org_contacts a, hz_relationships b

2516: and status = 'A';
2517: CURSOR org_contact IS
2518: select a.org_contact_id
2519: from
2520: hz_org_contacts a, hz_relationships b
2521: where b.party_id = p_party_id
2522: and a.party_relationship_id = b.relationship_id
2523: and b.STATUS = 'A' AND trunc(b.START_DATE) <= trunc(sysdate)
2524: AND trunc(nvl(b.END_DATE, sysdate)) >= trunc(sysdate);

Line 2525: --and a.status = 'A'; /* status column in hz_org_contacts is obseleted */

2521: where b.party_id = p_party_id
2522: and a.party_relationship_id = b.relationship_id
2523: and b.STATUS = 'A' AND trunc(b.START_DATE) <= trunc(sysdate)
2524: AND trunc(nvl(b.END_DATE, sysdate)) >= trunc(sysdate);
2525: --and a.status = 'A'; /* status column in hz_org_contacts is obseleted */
2526: l_party_type varchar2(30);
2527: begin
2528:
2529: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2701: from hz_org_contacts a, hz_relationships b, hz_cust_accounts c

2697: NVL(account_termination_date, sysdate));
2698:
2699: CURSOR person_relationship_cur IS
2700: SELECT b.party_id
2701: from hz_org_contacts a, hz_relationships b, hz_cust_accounts c
2702: where
2703: --a.status = 'A' and -- status column obseleted
2704: a.party_relationship_id = b.relationship_id
2705: and b.subject_id = p_party_id

Line 2717: hz_org_contacts a, hz_relationships b

2713:
2714: CURSOR org_contact IS
2715: select a.org_contact_id
2716: from
2717: hz_org_contacts a, hz_relationships b
2718: where
2719: b.party_id = p_party_id
2720: /* and a.status = 'A' vtariker: Status for hz_org_contacts is now obsolete */
2721: and b.relationship_id = a.party_relationship_id

Line 2720: /* and a.status = 'A' vtariker: Status for hz_org_contacts is now obsolete */

2716: from
2717: hz_org_contacts a, hz_relationships b
2718: where
2719: b.party_id = p_party_id
2720: /* and a.status = 'A' vtariker: Status for hz_org_contacts is now obsolete */
2721: and b.relationship_id = a.party_relationship_id
2722: and b.status = 'A'
2723: and (sysdate between nvl(b.start_date, sysdate) and nvl(b.end_date, sysdate));
2724:

Line 3060: hz_org_contacts org ,

3056:
3057: CURSOR C_party IS
3058: SELECT par.party_id
3059: FROM hz_relationships par,
3060: hz_org_contacts org ,
3061: hz_cust_accounts acc
3062: WHERE org.party_relationship_id = par.relationship_id
3063: AND org.org_contact_id = p_org_contact_id
3064: -- AND org.status = 'A' -- status column obseleted