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.PO_COMMUNICATION_PVT dependencies on PER_PHONES

Line 7048: tab.Now with this fix the buyers phone willbe taken from per_phones work

7044: PO_COMMUNICATION_PVT.g_buyer_email_address := null;
7045: PO_COMMUNICATION_PVT.g_buyer_fax := null; --Bug5671523
7046:
7047: /* Bug5191404 Buyer phone number was incorrectly taken from office details
7048: tab.Now with this fix the buyers phone willbe taken from per_phones work
7049: phone type.Commenting out the below sql and adding a new sql*/
7050:
7051: -- bug#5999438 modified the below sqls where clause date checking condition for work phone and work fax.
7052: -- added nvl to pph.date_from

Line 7061: FROM per_phones pph,

7057: pap.email_address,
7058: pph.phone_number
7059: INTO PO_COMMUNICATION_PVT.g_buyer_email_address,
7060: PO_COMMUNICATION_PVT.g_buyer_phone
7061: FROM per_phones pph,
7062: per_all_people_f pap
7063: WHERE pph.parent_id(+) = pap.person_id
7064: AND pph.parent_table(+) = 'PER_ALL_PEOPLE_F'
7065: AND pph.phone_type (+) = 'W1'

Line 7085: FROM per_phones pph,

7081: /*End Edit Akyanama Bug # 12970846 */
7082: SELECT
7083: pph.phone_number
7084: INTO PO_COMMUNICATION_PVT.g_buyer_fax
7085: FROM per_phones pph,
7086: per_all_people_f pap
7087: WHERE pph.parent_id(+) = pap.person_id
7088: AND pph.parent_table(+) = 'PER_ALL_PEOPLE_F'
7089: AND pph.phone_type(+) = 'WF'