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 662: AP_INVOICE_DISTRIBUTIONS AID,

658: SELECT
659: SUM(AID.AMOUNT) AMOUNT,
660: SUM(AID.BASE_AMOUNT) BASE_AMOUNT
661: FROM
662: AP_INVOICE_DISTRIBUTIONS AID,
663: AP_SYSTEM_PARAMETERS ASP
664: WHERE (AID.ORG_ID = ASP.ORG_ID)
665: AND ( AID.INVOICE_ID =CINVOICEAMOUNTEXEMPT.INVOICE_ID )
666: AND ( AID.LINE_TYPE_LOOKUP_CODE <> 'AWT' )

Line 1108: ' || ' from ap_invoice_distributions sub ' || '

1104: END IF;
1105: IF (P_POSTED_STATUS = 'ITEMS_POSTED') THEN
1106: IF (P_SYSTEM_ACCT_METHOD = 'ACCRUAL') THEN
1107: RET_TEXT := 'and not exists (select ''Unposted Item''' || '
1108: ' || ' from ap_invoice_distributions sub ' || '
1109: ' || ' where sub.invoice_id = d.invoice_id' || '
1110: ' || ' and sub.line_type_lookup_code = ''ITEM''
1111: ' || ' and sub.posted_flag <>''Y'')';
1112: ELSE

Line 1129: ' || ' from ap_invoice_distributions sub ' || '

1125: END IF;
1126: ELSIF (P_POSTED_STATUS = 'ITEMS_PARTIALLY_POSTED') THEN
1127: IF (P_SYSTEM_ACCT_METHOD = 'ACCRUAL') THEN
1128: RET_TEXT := 'and exists (select ''Posted Item''' || '
1129: ' || ' from ap_invoice_distributions sub ' || '
1130: ' || ' where sub.invoice_id = d.invoice_id' || '
1131: ' || ' and sub.line_type_lookup_code = ''ITEM''' || '
1132: ' || ' and sub.posted_flag =''Y''' || '
1133: ' || ' )' || '

Line 1135: ' || ' from ap_invoice_distributions sub ' || '

1131: ' || ' and sub.line_type_lookup_code = ''ITEM''' || '
1132: ' || ' and sub.posted_flag =''Y''' || '
1133: ' || ' )' || '
1134: ' || ' and exists (select ''Unposted Item''' || '
1135: ' || ' from ap_invoice_distributions sub ' || '
1136: ' || ' where sub.invoice_id = d.invoice_id' || '
1137: ' || ' and sub.line_type_lookup_code = ''ITEM''' || '
1138: ' || ' and sub.posted_flag <>''Y''' || '
1139: ' || ' )';

Line 1169: ' || ' from ap_invoice_distributions sub ' || '

1165: END IF;
1166: ELSIF (P_POSTED_STATUS = 'ITEMS_UNPOSTED') THEN
1167: IF (P_SYSTEM_ACCT_METHOD = 'ACCRUAL') THEN
1168: RET_TEXT := 'and not exists (select ''Posted Item''' || '
1169: ' || ' from ap_invoice_distributions sub ' || '
1170: ' || ' where sub.invoice_id = d.invoice_id' || '
1171: ' || ' and sub.line_type_lookup_code = ''ITEM''' || '
1172: ' || ' and sub.posted_flag = ''Y''' || '
1173: ' || ' )';

Line 1324: AP_INVOICE_DISTRIBUTIONS

1320: CURSOR C_ITEM_DATE IS
1321: SELECT
1322: MIN(ACCOUNTING_DATE)
1323: FROM
1324: AP_INVOICE_DISTRIBUTIONS
1325: WHERE INVOICE_ID = INVOICE_ID
1326: AND LINE_TYPE_LOOKUP_CODE = 'ITEM';
1327: FIRST_ACCOUNTING_DATE AP_INVOICE_DISTRIBUTIONS.ACCOUNTING_DATE%TYPE;
1328: BEGIN

Line 1327: FIRST_ACCOUNTING_DATE AP_INVOICE_DISTRIBUTIONS.ACCOUNTING_DATE%TYPE;

1323: FROM
1324: AP_INVOICE_DISTRIBUTIONS
1325: WHERE INVOICE_ID = INVOICE_ID
1326: AND LINE_TYPE_LOOKUP_CODE = 'ITEM';
1327: FIRST_ACCOUNTING_DATE AP_INVOICE_DISTRIBUTIONS.ACCOUNTING_DATE%TYPE;
1328: BEGIN
1329: OPEN C_ITEM_DATE;
1330: FETCH C_ITEM_DATE
1331: INTO FIRST_ACCOUNTING_DATE;