APPS.AP_APXWTGNR_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 72: ' || ' from ap_invoice_distributions sub ' || '

68: ,'yyyy');
69: BEGIN
70: P_GL_POSTED_STATUS := P_GL_POSTED_STATUS || '
71: ' || 'and exists (select ''Invoice Posting Date Ok''' || '
72: ' || ' from ap_invoice_distributions sub ' || '
73: ' || ' where sub.invoice_id = d.invoice_id' || '
74: ' || ' and sub.awt_group_id is not null' || '
75: ' || ' and sub.line_type_lookup_code = ' || '''ITEM''' || '
76: ' || ' and sub.accounting_date <= ' || '

Line 88: AP_INVOICE_DISTRIBUTIONS D

84: I.INVOICE_AMOUNT - NVL(I.AMOUNT_PAID
85: ,0) AMOUNT
86: FROM
87: AP_INVOICES I,
88: AP_INVOICE_DISTRIBUTIONS D
89: WHERE I.INVOICE_ID = D.INVOICE_ID
90: AND I.INVOICE_AMOUNT - NVL(I.AMOUNT_PAID
91: ,0) > 0
92: AND I.VENDOR_ID = NVL(P_SUPPLIER_ID

Line 416: AP_INVOICE_DISTRIBUTIONS

412: CURSOR C_ROW_EXISTS IS
413: SELECT
414: 'One Withholding Tax Distribution Exists'
415: FROM
416: AP_INVOICE_DISTRIBUTIONS
417: WHERE ACCOUNTING_DATE between NVL(P_DATE_FROM
418: ,ACCOUNTING_DATE)
419: AND NVL(P_DATE_TO
420: ,ACCOUNTING_DATE);

Line 660: AP_INVOICE_DISTRIBUTIONS

656: SELECT
657: SUM(AMOUNT) AMOUNT,
658: SUM(BASE_AMOUNT) BASE_AMOUNT
659: FROM
660: AP_INVOICE_DISTRIBUTIONS
661: WHERE ( INVOICE_ID = CINVOICEAMOUNTEXEMPT.INVOICE_ID )
662: AND ( LINE_TYPE_LOOKUP_CODE <> 'AWT' )
663: AND ( AWT_GROUP_ID is null );
664: AMOUNT NUMBER;

Line 1098: ' || ' from ap_invoice_distributions sub ' || '

1094: END IF;
1095: IF (P_POSTED_STATUS = 'ITEMS_POSTED') THEN
1096: IF (P_SYSTEM_ACCT_METHOD = 'ACCRUAL') THEN
1097: RET_TEXT := 'and not exists (select ''Unposted Item''' || '
1098: ' || ' from ap_invoice_distributions sub ' || '
1099: ' || ' where sub.invoice_id = d.invoice_id' || '
1100: ' || ' and sub.line_type_lookup_code = ''ITEM''
1101: ' || ' and sub.posted_flag <>''Y'')';
1102: ELSE

Line 1119: ' || ' from ap_invoice_distributions sub ' || '

1115: END IF;
1116: ELSIF (P_POSTED_STATUS = 'ITEMS_PARTIALLY_POSTED') THEN
1117: IF (P_SYSTEM_ACCT_METHOD = 'ACCRUAL') THEN
1118: RET_TEXT := 'and exists (select ''Posted Item''' || '
1119: ' || ' from ap_invoice_distributions sub ' || '
1120: ' || ' where sub.invoice_id = d.invoice_id' || '
1121: ' || ' and sub.line_type_lookup_code = ''ITEM''' || '
1122: ' || ' and sub.posted_flag =''Y''' || '
1123: ' || ' )' || '

Line 1125: ' || ' from ap_invoice_distributions sub ' || '

1121: ' || ' and sub.line_type_lookup_code = ''ITEM''' || '
1122: ' || ' and sub.posted_flag =''Y''' || '
1123: ' || ' )' || '
1124: ' || ' and exists (select ''Unposted Item''' || '
1125: ' || ' from ap_invoice_distributions sub ' || '
1126: ' || ' where sub.invoice_id = d.invoice_id' || '
1127: ' || ' and sub.line_type_lookup_code = ''ITEM''' || '
1128: ' || ' and sub.posted_flag <>''Y''' || '
1129: ' || ' )';

Line 1159: ' || ' from ap_invoice_distributions sub ' || '

1155: END IF;
1156: ELSIF (P_POSTED_STATUS = 'ITEMS_UNPOSTED') THEN
1157: IF (P_SYSTEM_ACCT_METHOD = 'ACCRUAL') THEN
1158: RET_TEXT := 'and not exists (select ''Posted Item''' || '
1159: ' || ' from ap_invoice_distributions sub ' || '
1160: ' || ' where sub.invoice_id = d.invoice_id' || '
1161: ' || ' and sub.line_type_lookup_code = ''ITEM''' || '
1162: ' || ' and sub.posted_flag = ''Y''' || '
1163: ' || ' )';

Line 1314: AP_INVOICE_DISTRIBUTIONS

1310: CURSOR C_ITEM_DATE IS
1311: SELECT
1312: MIN(ACCOUNTING_DATE)
1313: FROM
1314: AP_INVOICE_DISTRIBUTIONS
1315: WHERE INVOICE_ID = INVOICE_ID
1316: AND LINE_TYPE_LOOKUP_CODE = 'ITEM';
1317: FIRST_ACCOUNTING_DATE AP_INVOICE_DISTRIBUTIONS.ACCOUNTING_DATE%TYPE;
1318: BEGIN

Line 1317: FIRST_ACCOUNTING_DATE AP_INVOICE_DISTRIBUTIONS.ACCOUNTING_DATE%TYPE;

1313: FROM
1314: AP_INVOICE_DISTRIBUTIONS
1315: WHERE INVOICE_ID = INVOICE_ID
1316: AND LINE_TYPE_LOOKUP_CODE = 'ITEM';
1317: FIRST_ACCOUNTING_DATE AP_INVOICE_DISTRIBUTIONS.ACCOUNTING_DATE%TYPE;
1318: BEGIN
1319: OPEN C_ITEM_DATE;
1320: FETCH C_ITEM_DATE
1321: INTO FIRST_ACCOUNTING_DATE;