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_INVOICE_LINES_UTILITY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 49: FROM ap_invoice_distributions

45: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
46:
47: CURSOR encumbrance_flag_cursor is
48: SELECT nvl(encumbered_flag,'N')
49: FROM ap_invoice_distributions
50: WHERE invoice_id = p_invoice_id
51: AND invoice_line_number = p_line_number;
52: BEGIN
53:

Line 117: | -- MOAC. Use ap_invoice_distributions_all table instead of SO view

113: | -- accrual) for the distributions. The rest is to cover one specific
114: | -- case when some of the distributions are fully posting (Y) and some
115: | -- are unposting (N). The status should be partial (P).
116: | --
117: | -- MOAC. Use ap_invoice_distributions_all table instead of SO view
118: | -- since this procedure is called when policy context is not set to
119: | -- the corresponding OU for the invoice_id
120: |
121: | MODIFICATION HISTORY

Line 140: FROM ap_invoice_distributions_all

136:
137:
138: CURSOR posting_cursor IS
139: SELECT cash_posted_flag
140: FROM ap_invoice_distributions_all
141: WHERE invoice_id = p_invoice_id
142: AND invoice_line_number = p_line_number
143: AND l_cash_basis_flag = 'Y'
144: UNION

Line 146: FROM ap_invoice_distributions_all

142: AND invoice_line_number = p_line_number
143: AND l_cash_basis_flag = 'Y'
144: UNION
145: SELECT accrual_posted_flag
146: FROM ap_invoice_distributions_all
147: WHERE invoice_id = p_invoice_id
148: AND invoice_line_number = p_line_number
149: AND l_cash_basis_flag <> 'Y'
150: UNION

Line 152: FROM ap_invoice_distributions_all

148: AND invoice_line_number = p_line_number
149: AND l_cash_basis_flag <> 'Y'
150: UNION
151: SELECT 'P'
152: FROM ap_invoice_distributions_all
153: WHERE invoice_id = p_invoice_id
154: AND invoice_line_number = p_line_number
155: AND ( (cash_posted_flag = 'Y'
156: AND l_cash_basis_flag = 'Y')

Line 162: FROM ap_invoice_distributions_all

158: (accrual_posted_flag = 'Y'
159: AND l_cash_basis_flag <> 'Y'))
160: AND EXISTS
161: (SELECT 'An N is also in the valid flags'
162: FROM ap_invoice_distributions_all
163: WHERE invoice_id = p_invoice_id
164: AND invoice_line_number = p_line_number
165: AND ((cash_posted_flag = 'N'
166: AND l_cash_basis_flag = 'Y')

Line 269: FROM ap_invoice_distributions_all

265: -- (NULL). The status should be needs reapproval (N).
266: --
267: CURSOR approval_cursor IS
268: SELECT nvl(match_status_flag, 'N')
269: FROM ap_invoice_distributions_all
270: WHERE invoice_id = p_invoice_id
271: AND invoice_line_number = p_line_number;
272:
273: BEGIN

Line 330: FROM ap_invoice_distributions_all aid

326: -- only if the count is more than 0.
327: --
328: SELECT count(*)
329: INTO match_flag_cnt
330: FROM ap_invoice_distributions_all aid
331: WHERE aid.invoice_id = p_invoice_id
332: AND aid.invoice_line_number = p_line_number
333: AND aid.match_status_flag IS NOT NULL
334: AND rownum < 2;

Line 495: FROM ap_invoice_distributions AID

491: l_po_not_approved VARCHAR2(1); --bug6009101
492: l_org_id ap_invoices_all.org_id%type; -- for bug 5936290
493: CURSOR dist_gl_date_Cur IS
494: SELECT accounting_date
495: FROM ap_invoice_distributions AID
496: WHERE AID.invoice_id = p_line_rec.invoice_id
497: AND AID.invoice_line_number = p_line_rec.line_number
498: AND NVL(AID.reversal_flag, 'N') <> 'Y';
499:

Line 592: ap_invoice_distributions AID,

588: BEGIN
589: SELECT count(*)
590: INTO l_po_dist_count
591: FROM po_distributions_all POD,
592: ap_invoice_distributions AID,
593: ap_invoices ai,
594: po_line_locations PLL,
595: po_lines PL
596: WHERE POD.po_distribution_id = AID.po_distribution_id

Line 653: ap_invoice_distributions_all AID

649:
650: SELECT count(*)
651: INTO l_rcv_dist_count
652: FROM rcv_transactions RT,
653: ap_invoice_distributions_all AID
654: WHERE RT.transaction_id = AID.rcv_transaction_id
655: AND AID.invoice_id = p_line_rec.invoice_id
656: AND AID.invoice_line_number = p_line_rec.line_number
657: AND AID.rcv_transaction_id is not null

Line 669: FROM ap_invoice_distributions_all aid1

665: nvl( AID1.corrected_quantity,0 ) +
666: nvl( AID1.quantity_invoiced,0 )
667: )
668: )
669: FROM ap_invoice_distributions_all aid1
670: WHERE aid1.invoice_id = aid.invoice_id
671: AND aid1.invoice_line_number = aid.invoice_line_number
672: AND aid1.rcv_transaction_id=aid.rcv_transaction_id
673: )

Line 677: FROM ap_invoice_distributions_all aid2

673: )
674: OR
675: NVL(rt.amount_billed,0) < (
676: SELECT SUM(NVL(AID2.amount,0))
677: FROM ap_invoice_distributions_all aid2
678: WHERE aid2.invoice_id = aid.invoice_id
679: AND aid2.invoice_line_number = aid.invoice_line_number
680: AND aid2.rcv_transaction_id=aid.rcv_transaction_id
681: )

Line 824: FROM ap_invoice_distributions D

820: +-----------------------------------------------------------------*/
821:
822: SELECT count(*)
823: INTO l_invalid_acct_count
824: FROM ap_invoice_distributions D
825: WHERE D.invoice_id = p_line_rec.invoice_id
826: AND D.invoice_line_number = p_line_rec.line_number
827: AND D.posted_flag IN ('N', 'P')
828: AND ((EXISTS (select 'x'

Line 864: FROM ap_invoice_distributions AID

860:
861: /*
862: SELECT count(*)
863: INTO l_reference_count
864: FROM ap_invoice_distributions AID
865: WHERE NVL(AID.cancellation_flag, 'N') <> 'Y'
866: AND NVL(AID.reversal_flag, 'N') <> 'Y'
867: AND AID.invoice_id = p_line_rec.invoice_id
868: AND AID.invoice_line_number <> p_line_rec.line_number

Line 872: FROM ap_invoice_distributions AID2

868: AND AID.invoice_line_number <> p_line_rec.line_number
869: AND AID.charge_applicable_to_dist_id IS NOT NULL
870: AND AID.charge_applicable_to_dist_id IN
871: ( SELECT AID2.invoice_distribution_id
872: FROM ap_invoice_distributions AID2
873: WHERE AID2.invoice_id = p_line_rec.invoice_id
874: AND AID2.invoice_line_number = p_line_rec.line_number
875: AND NVL(AID2.cancellation_flag, 'N') <> 'Y'
876: AND NVL(AID2.reversal_flag, 'N') <> 'Y' );

Line 920: FROM ap_invoice_distributions aid

916: WHERE AIL.invoice_id = P_line_rec.invoice_id
917: AND AIL.line_number = P_line_rec.line_number
918: AND AIL.line_type_lookup_code = 'AWT'
919: AND NOT EXISTS ( SELECT invoice_distribution_id
920: FROM ap_invoice_distributions aid
921: WHERE aid.invoice_id = AIL.invoice_id
922: AND aid.invoice_line_number = AIL.line_number
923: AND awt_flag = 'M' )
924: AND AI.invoice_id = AIL.invoice_id

Line 1146: debug_info := 'Select from ap_invoice_distributions_all';

1142: current_calling_sequence :=
1143: 'AP_INVOICE_LINES_UTILITY_PKG.IS_LINE_DISTS_TRANS_FA<-'
1144: ||p_Calling_Sequence;
1145:
1146: debug_info := 'Select from ap_invoice_distributions_all';
1147:
1148: Select count(*)
1149: Into dummy
1150: From ap_invoice_distributions_all

Line 1150: From ap_invoice_distributions_all

1146: debug_info := 'Select from ap_invoice_distributions_all';
1147:
1148: Select count(*)
1149: Into dummy
1150: From ap_invoice_distributions_all
1151: Where invoice_id = p_Invoice_Id
1152: And invoice_line_number = p_Line_Number
1153: And assets_addition_flag = 'Y';
1154:

Line 1203: debug_info := 'Select from ap_invoice_distributions_all';

1199: current_calling_sequence :=
1200: 'AP_INVOICE_LINES_UTILITY_PKG.LINE_DISTS_ACCT_EVENT_CREATED<-'
1201: ||p_Calling_Sequence;
1202:
1203: debug_info := 'Select from ap_invoice_distributions_all';
1204:
1205: Select count(*)
1206: Into dummy
1207: From ap_invoice_distributions_all

Line 1207: From ap_invoice_distributions_all

1203: debug_info := 'Select from ap_invoice_distributions_all';
1204:
1205: Select count(*)
1206: Into dummy
1207: From ap_invoice_distributions_all
1208: Where invoice_id = p_Invoice_Id
1209: And invoice_line_number = p_Line_Number
1210: And accounting_event_id Is Not Null;
1211:

Line 1322: From ap_invoice_distributions_all AID

1318: debug_info := 'Select from ap_invoic_distributions_all';
1319:
1320: Select count(*)
1321: Into dummy
1322: From ap_invoice_distributions_all AID
1323: Where NVL(AID.cancellation_flag, 'N') <> 'Y'
1324: And NVL(AID.reversal_flag, 'N') <> 'Y'
1325: And AID.invoice_id = p_invoice_id
1326: And AID.invoice_line_number <> p_line_number

Line 1330: From ap_invoice_distributions_all AID2

1326: And AID.invoice_line_number <> p_line_number
1327: And AID.charge_applicable_to_dist_id IS NOT NULL
1328: And AID.charge_applicable_to_dist_id In
1329: (Select AID2.invoice_distribution_id
1330: From ap_invoice_distributions_all AID2
1331: Where AID2.invoice_id = p_Invoice_Id
1332: And AID2.invoice_line_number = p_Line_Number
1333: And NVL(AID2.cancellation_flag, 'N') <> 'Y'
1334: And NVL(AID2.reversal_flag, 'N') <> 'Y' );

Line 1447: From ap_invoice_distributions_all

1443: debug_info := 'Select from ap_invoic_distributions_all';
1444:
1445: Select count(*)
1446: Into dummy
1447: From ap_invoice_distributions_all
1448: Where invoice_id = p_Invoice_Id
1449: And invoice_line_number = p_Line_Number
1450: And pa_addition_flag In ('T', 'Y', 'Z') ;
1451:

Line 1577: From ap_invoice_distributions

1573:
1574: l_packet_id number := '';
1575: Cursor packet_id_cursor Is
1576: Select decode(count(distinct(packet_id)),1,max(packet_id),'')
1577: From ap_invoice_distributions
1578: Where invoice_id = p_Invoice_Id
1579: And invoice_line_number = p_Line_Number
1580: And packet_id is not null;
1581:

Line 1622: FROM ap_invoice_lines AIL, ap_invoice_distributions D

1618: IS
1619:
1620: CURSOR Dist_Var_Cur IS
1621: SELECT 'Dist Total <> Invoice Line Amount'
1622: FROM ap_invoice_lines AIL, ap_invoice_distributions D
1623: WHERE AIL.invoice_id = D.invoice_id
1624: AND AIL.line_number = p_line_number
1625: AND AIL.invoice_id = p_invoice_id
1626: AND AIL.line_number = D.invoice_line_number

Line 1704: ap_invoice_distributions AID

1700: IS
1701: CURSOR Invoice_Validation IS
1702: SELECT count(*)
1703: FROM po_distributions_all POD,
1704: ap_invoice_distributions AID
1705: WHERE POD.po_distribution_id = AID.po_distribution_id
1706: AND AID.invoice_id = P_Invoice_Id
1707: AND POD.org_id = AID.org_id
1708: AND AID.invoice_line_number = P_Line_Number

Line 2200: l_awt_flag ap_invoice_distributions_all.awt_flag%TYPE;

2196: p_invoice_id IN NUMBER,
2197: p_line_number IN NUMBER )
2198: RETURN VARCHAR2
2199: IS
2200: l_awt_flag ap_invoice_distributions_all.awt_flag%TYPE;
2201:
2202: BEGIN
2203:
2204: SELECT awt_flag

Line 2206: FROM ap_invoice_distributions_all

2202: BEGIN
2203:
2204: SELECT awt_flag
2205: INTO l_awt_flag
2206: FROM ap_invoice_distributions_all
2207: WHERE invoice_id = p_invoice_id
2208: AND invoice_line_number = p_line_number
2209: AND rownum = 1;
2210: