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_IAW_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 829: FROM AP_INVOICE_DISTRIBUTIONS_ALL

825: ELSIF l_class(l_rec) = 'project code' THEN
826:
827: SELECT Invoice_Line_Number
828: INTO l_line_num
829: FROM AP_INVOICE_DISTRIBUTIONS_ALL
830: WHERE project_id =l_ids(l_rec);
831: ELSIF l_class(l_rec) =
832: ame_util.costCenterItemClassName THEN
833:

Line 836: FROM AP_INVOICE_DISTRIBUTIONS_ALL

832: ame_util.costCenterItemClassName THEN
833:
834: SELECT Invoice_Line_Number
835: INTO l_line_num
836: FROM AP_INVOICE_DISTRIBUTIONS_ALL
837: WHERE project_id =l_ids(l_rec);
838: --distributions
839: ELSIF l_class(l_rec) <>
840: ame_util.lineItemItemClassName

Line 846: FROM AP_INVOICE_DISTRIBUTIONS_ALL

842: ame_util.headerItemClassName THEN
843:
844: SELECT Invoice_Line_Number
845: INTO l_line_num
846: FROM AP_INVOICE_DISTRIBUTIONS_ALL
847: WHERE invoice_distribution_id = l_ids(l_rec);
848:
849: END IF; --l_class
850:

Line 950: FROM AP_INVOICE_DISTRIBUTIONS_ALL

946: ELSIF l_next_approver.item_class = 'project code' THEN
947:
948: SELECT Invoice_Line_Number
949: INTO l_line_num
950: FROM AP_INVOICE_DISTRIBUTIONS_ALL
951: WHERE project_id = l_next_approver.item_id;
952: ELSIF l_next_approver.item_class =
953: ame_util.costCenterItemClassName THEN
954:

Line 957: FROM AP_INVOICE_DISTRIBUTIONS_ALL

953: ame_util.costCenterItemClassName THEN
954:
955: SELECT Invoice_Line_Number
956: INTO l_line_num
957: FROM AP_INVOICE_DISTRIBUTIONS_ALL
958: WHERE project_id = l_next_approver.item_id;
959: --distributions
960: ELSIF l_next_approver.item_class <>
961: ame_util.lineItemItemClassName

Line 967: FROM AP_INVOICE_DISTRIBUTIONS_ALL

963: ame_util.headerItemClassName THEN
964:
965: SELECT Invoice_Line_Number
966: INTO l_line_num
967: FROM AP_INVOICE_DISTRIBUTIONS_ALL
968: WHERE invoice_distribution_id = l_next_approver.item_id;
969:
970: END IF; --l_class
971:

Line 1172: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1168: ELSIF l_class(l_rec) = 'project code' THEN
1169:
1170: SELECT Invoice_Line_Number
1171: INTO l_line_num
1172: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1173: WHERE project_id =l_ids(l_rec);
1174: ELSIF l_class(l_rec) =
1175: ame_util.costCenterItemClassName THEN
1176:

Line 1179: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1175: ame_util.costCenterItemClassName THEN
1176:
1177: SELECT Invoice_Line_Number
1178: INTO l_line_num
1179: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1180: WHERE project_id =l_ids(l_rec);
1181: --distributions
1182: ELSIF l_class(l_rec) <>
1183: ame_util.lineItemItemClassName

Line 1189: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1185: ame_util.headerItemClassName THEN
1186:
1187: SELECT Invoice_Line_Number
1188: INTO l_line_num
1189: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1190: WHERE invoice_distribution_id = l_ids(l_rec);
1191:
1192: END IF; --l_class
1193:

Line 1248: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1244: ELSIF l_next_approver.item_class = 'project code' THEN
1245:
1246: SELECT Invoice_Line_Number
1247: INTO l_line_num
1248: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1249: WHERE project_id = l_next_approver.item_id;
1250: ELSIF l_next_approver.item_class =
1251: ame_util.costCenterItemClassName THEN
1252:

Line 1255: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1251: ame_util.costCenterItemClassName THEN
1252:
1253: SELECT Invoice_Line_Number
1254: INTO l_line_num
1255: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1256: WHERE project_id = l_next_approver.item_id;
1257: --distributions
1258: ELSIF l_next_approver.item_class <>
1259: ame_util.lineItemItemClassName

Line 1265: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1261: ame_util.headerItemClassName THEN
1262:
1263: SELECT Invoice_Line_Number
1264: INTO l_line_num
1265: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1266: WHERE invoice_distribution_id = l_next_approver.item_id;
1267:
1268: END IF; --l_class
1269:

Line 3279: FROM ap_invoice_distributions_all

3275: END IF;
3276:
3277: SELECT dist_code_combination_id,set_of_books_id
3278: INTO l_ccid,l_sob
3279: FROM ap_invoice_distributions_all
3280: WHERE invoice_distribution_id=p_dist_id;
3281:
3282: SELECT chart_of_accounts_id
3283: INTO l_chart_of_accounts_id

Line 3373: FROM ap_invoice_distributions_all

3369: ELSIF p_attribute_name= 'SUPPLIER_INVOICE_PROJECT_RELATED' THEN
3370:
3371: SELECT count(invoice_distribution_id)
3372: INTO l_count_pa_rel
3373: FROM ap_invoice_distributions_all
3374: WHERE invoice_id = p_invoice_id
3375: AND project_id is not null;
3376:
3377: IF l_count_pa_rel >0 THEN

Line 3425: FROM ap_invoice_distributions_all aid,

3421: SELECT employee_number
3422: INTO l_return_val
3423: FROM per_all_people_f pap
3424: WHERE person_id = (SELECT ph.agent_id
3425: FROM ap_invoice_distributions_all aid,
3426: po_distributions_all pd,
3427: po_headers_all ph
3428: WHERE pd.po_distribution_id =
3429: aid.po_distribution_id

Line 3445: FROM ap_invoice_distributions_all aid,

3441: INTO l_return_val
3442: FROM per_all_people_f pap
3443: WHERE person_id = (
3444: SELECT pd.deliver_to_person_id
3445: FROM ap_invoice_distributions_all aid,
3446: po_distributions_all pd
3447: WHERE pd.po_distribution_id =
3448: aid.po_distribution_id
3449: AND aid.invoice_distribution_id =