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 127: | -- MOAC. Use ap_invoice_distributions_all table instead of SO view

123: | -- accrual) for the distributions. The rest is to cover one specific
124: | -- case when some of the distributions are fully posting (Y) and some
125: | -- are unposting (N). The status should be partial (P).
126: | --
127: | -- MOAC. Use ap_invoice_distributions_all table instead of SO view
128: | -- since this procedure is called when policy context is not set to
129: | -- the corresponding OU for the invoice_id
130: |
131: | MODIFICATION HISTORY

Line 150: FROM ap_invoice_distributions_all

146:
147:
148: CURSOR posting_cursor IS
149: SELECT cash_posted_flag
150: FROM ap_invoice_distributions_all
151: WHERE invoice_id = p_invoice_id
152: AND invoice_line_number = p_line_number
153: AND l_cash_basis_flag = 'Y'
154: UNION

Line 156: FROM ap_invoice_distributions_all

152: AND invoice_line_number = p_line_number
153: AND l_cash_basis_flag = 'Y'
154: UNION
155: SELECT accrual_posted_flag
156: FROM ap_invoice_distributions_all
157: WHERE invoice_id = p_invoice_id
158: AND invoice_line_number = p_line_number
159: AND l_cash_basis_flag <> 'Y'
160: UNION

Line 162: FROM ap_invoice_distributions_all

158: AND invoice_line_number = p_line_number
159: AND l_cash_basis_flag <> 'Y'
160: UNION
161: SELECT 'P'
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 = 'Y'
166: AND l_cash_basis_flag = 'Y')

Line 172: FROM ap_invoice_distributions_all

168: (accrual_posted_flag = 'Y'
169: AND l_cash_basis_flag <> 'Y'))
170: AND EXISTS
171: (SELECT 'An N is also in the valid flags'
172: FROM ap_invoice_distributions_all
173: WHERE invoice_id = p_invoice_id
174: AND invoice_line_number = p_line_number
175: AND ((cash_posted_flag = 'N'
176: AND l_cash_basis_flag = 'Y')

Line 287: FROM ap_invoice_distributions_all

283: -- (NULL). The status should be needs reapproval (N).
284: --
285: CURSOR approval_cursor IS
286: SELECT nvl(match_status_flag, 'N')
287: FROM ap_invoice_distributions_all
288: WHERE invoice_id = p_invoice_id
289: AND invoice_line_number = p_line_number;
290:
291: BEGIN

Line 348: FROM ap_invoice_distributions_all aid

344: -- only if the count is more than 0.
345: --
346: SELECT count(*)
347: INTO match_flag_cnt
348: FROM ap_invoice_distributions_all aid
349: WHERE aid.invoice_id = p_invoice_id
350: AND aid.invoice_line_number = p_line_number
351: AND aid.match_status_flag IS NOT NULL
352: AND rownum < 2;

Line 519: FROM ap_invoice_distributions AID

515: l_po_not_approved VARCHAR2(1); --bug6009101
516: l_org_id ap_invoices_all.org_id%type; -- for bug 5936290
517: CURSOR dist_gl_date_Cur IS
518: SELECT accounting_date
519: FROM ap_invoice_distributions AID
520: WHERE AID.invoice_id = p_line_rec.invoice_id
521: AND AID.invoice_line_number = p_line_rec.line_number
522: AND NVL(AID.reversal_flag, 'N') <> 'Y';
523:

Line 744: ap_invoice_distributions AID,

740: BEGIN
741: SELECT count(*)
742: INTO l_po_dist_count
743: FROM po_distributions_all POD,
744: ap_invoice_distributions AID,
745: ap_invoices ai,
746: po_line_locations PLL,
747: po_lines PL
748: WHERE POD.po_distribution_id = AID.po_distribution_id

Line 805: ap_invoice_distributions_all AID

801:
802: SELECT count(*)
803: INTO l_rcv_dist_count
804: FROM rcv_transactions RT,
805: ap_invoice_distributions_all AID
806: WHERE RT.transaction_id = AID.rcv_transaction_id
807: AND AID.invoice_id = p_line_rec.invoice_id
808: AND AID.invoice_line_number = p_line_rec.line_number
809: AND AID.rcv_transaction_id is not null

Line 821: FROM ap_invoice_distributions_all aid1

817: nvl( AID1.corrected_quantity,0 ) +
818: nvl( AID1.quantity_invoiced,0 )
819: )
820: )
821: FROM ap_invoice_distributions_all aid1
822: WHERE aid1.invoice_id = aid.invoice_id
823: AND aid1.invoice_line_number = aid.invoice_line_number
824: AND aid1.rcv_transaction_id=aid.rcv_transaction_id
825: )

Line 830: FROM ap_invoice_distributions_all aid2

826: OR
827: NVL(rt.amount_billed,0) < (
828: SELECT SUM(DECODE(AID2.dist_match_type, --Bug11783854
829: 'OTHER_TO_RECEIPT',0,NVL(AID2.amount,0)))
830: FROM ap_invoice_distributions_all aid2
831: WHERE aid2.invoice_id = aid.invoice_id
832: AND aid2.invoice_line_number = aid.invoice_line_number
833: AND aid2.rcv_transaction_id=aid.rcv_transaction_id
834: )

Line 851: FROM ap_invoice_distributions D

847: +-----------------------------------------------------------------*/
848:
849: SELECT count(*)
850: INTO l_invalid_acct_count
851: FROM ap_invoice_distributions D
852: WHERE D.invoice_id = p_line_rec.invoice_id
853: AND D.invoice_line_number = p_line_rec.line_number
854: AND D.posted_flag IN ('N', 'P')
855: AND ((EXISTS (select 'x'

Line 875: FROM ap_invoice_distributions aid

871: l_valid_alt_acct_exists := 0;
872:
873: SELECT count(1)
874: INTO l_valid_alt_acct_exists
875: FROM ap_invoice_distributions aid
876: , gl_code_combinations glcc
877: WHERE aid.invoice_id = p_line_rec.invoice_id
878: AND aid.invoice_line_number = p_line_rec.line_number
879: AND aid.posted_flag IN ('N', 'P')

Line 918: FROM ap_invoice_distributions AID

914:
915: /*
916: SELECT count(*)
917: INTO l_reference_count
918: FROM ap_invoice_distributions AID
919: WHERE NVL(AID.cancellation_flag, 'N') <> 'Y'
920: AND NVL(AID.reversal_flag, 'N') <> 'Y'
921: AND AID.invoice_id = p_line_rec.invoice_id
922: AND AID.invoice_line_number <> p_line_rec.line_number

Line 926: FROM ap_invoice_distributions AID2

922: AND AID.invoice_line_number <> p_line_rec.line_number
923: AND AID.charge_applicable_to_dist_id IS NOT NULL
924: AND AID.charge_applicable_to_dist_id IN
925: ( SELECT AID2.invoice_distribution_id
926: FROM ap_invoice_distributions AID2
927: WHERE AID2.invoice_id = p_line_rec.invoice_id
928: AND AID2.invoice_line_number = p_line_rec.line_number
929: AND NVL(AID2.cancellation_flag, 'N') <> 'Y'
930: AND NVL(AID2.reversal_flag, 'N') <> 'Y' );

Line 975: FROM ap_invoice_distributions aid

971: AND AIL.line_number = P_line_rec.line_number
972: AND AIL.line_type_lookup_code = 'AWT'
973: /*bug12865213, commented exists clause
974: AND NOT EXISTS ( SELECT invoice_distribution_id
975: FROM ap_invoice_distributions aid
976: WHERE aid.invoice_id = AIL.invoice_id
977: AND aid.invoice_line_number = AIL.line_number
978: AND awt_flag = 'M' )
979: */

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

1214: current_calling_sequence :=
1215: 'AP_INVOICE_LINES_UTILITY_PKG.IS_LINE_DISTS_TRANS_FA<-'
1216: ||p_Calling_Sequence;
1217:
1218: debug_info := 'Select from ap_invoice_distributions_all';
1219:
1220: Select count(*)
1221: Into dummy
1222: From ap_invoice_distributions_all

Line 1222: From ap_invoice_distributions_all

1218: debug_info := 'Select from ap_invoice_distributions_all';
1219:
1220: Select count(*)
1221: Into dummy
1222: From ap_invoice_distributions_all
1223: Where invoice_id = p_Invoice_Id
1224: And invoice_line_number = p_Line_Number
1225: And assets_addition_flag = 'Y';
1226:

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

1271: current_calling_sequence :=
1272: 'AP_INVOICE_LINES_UTILITY_PKG.LINE_DISTS_ACCT_EVENT_CREATED<-'
1273: ||p_Calling_Sequence;
1274:
1275: debug_info := 'Select from ap_invoice_distributions_all';
1276:
1277: Select count(*)
1278: Into dummy
1279: From ap_invoice_distributions_all

Line 1279: From ap_invoice_distributions_all

1275: debug_info := 'Select from ap_invoice_distributions_all';
1276:
1277: Select count(*)
1278: Into dummy
1279: From ap_invoice_distributions_all
1280: Where invoice_id = p_Invoice_Id
1281: And invoice_line_number = p_Line_Number
1282: And accounting_event_id Is Not Null;
1283:

Line 1394: From ap_invoice_distributions_all AID

1390: debug_info := 'Select from ap_invoic_distributions_all';
1391:
1392: Select count(*)
1393: Into dummy
1394: From ap_invoice_distributions_all AID
1395: Where NVL(AID.cancellation_flag, 'N') <> 'Y'
1396: And NVL(AID.reversal_flag, 'N') <> 'Y'
1397: And AID.invoice_id = p_invoice_id
1398: --Bug9323585 : Commented line to check for inclusive tax also

Line 1403: From ap_invoice_distributions_all AID2

1399: --And AID.invoice_line_number <> p_line_number
1400: And AID.charge_applicable_to_dist_id IS NOT NULL
1401: And AID.charge_applicable_to_dist_id In
1402: (Select AID2.invoice_distribution_id
1403: From ap_invoice_distributions_all AID2
1404: Where AID2.invoice_id = p_Invoice_Id
1405: And AID2.invoice_line_number = p_Line_Number
1406: And NVL(AID2.cancellation_flag, 'N') <> 'Y'
1407: And NVL(AID2.reversal_flag, 'N') <> 'Y' );

Line 1522: From ap_invoice_distributions_all

1518: debug_info := 'Select from ap_invoic_distributions_all';
1519:
1520: Select count(*)
1521: Into dummy
1522: From ap_invoice_distributions_all
1523: Where invoice_id = p_Invoice_Id
1524: And invoice_line_number = p_Line_Number
1525: And pa_addition_flag In ('T', 'Y', 'Z') ;
1526:

Line 1652: From ap_invoice_distributions

1648:
1649: l_packet_id number := '';
1650: Cursor packet_id_cursor Is
1651: Select decode(count(distinct(packet_id)),1,max(packet_id),'')
1652: From ap_invoice_distributions
1653: Where invoice_id = p_Invoice_Id
1654: And invoice_line_number = p_Line_Number
1655: And packet_id is not null;
1656:

Line 1697: FROM ap_invoice_lines AIL, ap_invoice_distributions D

1693: IS
1694:
1695: CURSOR Dist_Var_Cur IS
1696: SELECT 'Dist Total <> Invoice Line Amount'
1697: FROM ap_invoice_lines AIL, ap_invoice_distributions D
1698: WHERE AIL.invoice_id = D.invoice_id
1699: AND AIL.line_number = p_line_number
1700: AND AIL.invoice_id = p_invoice_id
1701: AND AIL.line_number = D.invoice_line_number

Line 1779: ap_invoice_distributions AID

1775: IS
1776: CURSOR Invoice_Validation IS
1777: SELECT count(*)
1778: FROM po_distributions_all POD,
1779: ap_invoice_distributions AID
1780: WHERE POD.po_distribution_id = AID.po_distribution_id
1781: AND AID.invoice_id = P_Invoice_Id
1782: AND POD.org_id = AID.org_id
1783: AND AID.invoice_line_number = P_Line_Number

Line 2275: l_awt_flag ap_invoice_distributions_all.awt_flag%TYPE;

2271: p_invoice_id IN NUMBER,
2272: p_line_number IN NUMBER )
2273: RETURN VARCHAR2
2274: IS
2275: l_awt_flag ap_invoice_distributions_all.awt_flag%TYPE;
2276:
2277: BEGIN
2278:
2279: SELECT awt_flag

Line 2281: FROM ap_invoice_distributions_all

2277: BEGIN
2278:
2279: SELECT awt_flag
2280: INTO l_awt_flag
2281: FROM ap_invoice_distributions_all
2282: WHERE invoice_id = p_invoice_id
2283: AND invoice_line_number = p_line_number
2284: AND rownum = 1;
2285: