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.AP_WFAPPROVAL_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 1069: po_distributions_all pd,

1065: INTO l_return_val
1066: FROM per_all_people_f pap
1067: WHERE person_id = (SELECT ph.agent_id
1068: FROM ap_invoice_distributions_all aid,
1069: po_distributions_all pd,
1070: po_headers_all ph
1071: WHERE pd.po_distribution_id =
1072: aid.po_distribution_id
1073: AND pd.po_header_id = ph.po_header_id

Line 1083: PO_DISTRIBUTIONS_ALL PD,

1079: --added for bug 13576488
1080: SELECT Pap.EMPLOYEE_NUMBER
1081: into l_return_val FROM
1082: AP_INVOICE_DISTRIBUTIONS_ALL AID,
1083: PO_DISTRIBUTIONS_ALL PD,
1084: PO_HEADERS_ALL PH,
1085: PER_ALL_PEOPLE_F PAP
1086: WHERE AID.INVOICE_DISTRIBUTION_ID = p_dist_id
1087: AND PD.PO_DISTRIBUTION_ID = AID.PO_DISTRIBUTION_ID

Line 1102: po_distributions_all pd

1098: INTO l_return_val
1099: FROM per_all_people_f pap
1100: WHERE person_id = (SELECT pd.deliver_to_person_id
1101: FROM ap_invoice_distributions_all aid,
1102: po_distributions_all pd
1103: WHERE pd.po_distribution_id =
1104: aid.po_distribution_id
1105: AND aid.invoice_distribution_id =
1106: p_dist_id

Line 1114: po_distributions_all pd,

1110: --added for bug 13576488
1111: SELECT pap.employee_number
1112: into l_return_val
1113: FROM ap_invoice_distributions_all aid,
1114: po_distributions_all pd,
1115: per_all_people_f pap
1116: WHERE pd.po_distribution_id =aid.po_distribution_id
1117: AND aid.invoice_distribution_id =p_dist_id
1118: AND pd.creation_date >= pap.effective_start_date