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 AP_INVOICE_DISTRIBUTIONS_ALL

Line 83: FROM ap_invoice_distributions_all

79: BEGIN
80:
81: SELECT dist_code_combination_id,set_of_books_id
82: INTO l_ccid,l_sob
83: FROM ap_invoice_distributions_all
84: WHERE invoice_distribution_id=p_dist_id;
85:
86: SELECT chart_of_accounts_id
87: INTO l_chart_of_accounts_id

Line 1048: FROM ap_invoice_distributions_all

1044: ELSIF p_attribute_name = 'SUPPLIER_INVOICE_PROJECT_RELATED' THEN
1045:
1046: SELECT count(invoice_distribution_id)
1047: INTO l_count_pa_rel
1048: FROM ap_invoice_distributions_all
1049: WHERE invoice_id = p_invoice_id
1050: AND project_id is not null;
1051:
1052: IF l_count_pa_rel >0 THEN

Line 1068: FROM ap_invoice_distributions_all aid,

1064: /* SELECT employee_number
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

Line 1082: AP_INVOICE_DISTRIBUTIONS_ALL AID,

1078: */
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

Line 1101: FROM ap_invoice_distributions_all aid,

1097: /* SELECT employee_number
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 =

Line 1113: FROM ap_invoice_distributions_all aid,

1109: */
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