DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 2196: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,

2192: tax_dist.award_id) award_id,
2193: NULL credit_card_trx_id,
2194: tax_dist.dist_match_type dist_match_type,
2195: tax_dist.rcv_transaction_id rcv_transaction_id,
2196: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,
2197: tax_dist.invoice_distribution_id parent_reversal_id,
2198: tax_dist.tax_recoverable_flag tax_recoverable_flag,
2199: NULL merchant_document_number,
2200: NULL merchant_name,

Line 2225: ap_invoice_distributions_s.CURRVAL, NULL) related_id,

2221: zx_dist.trx_line_dist_id charge_applicable_to_dist_id,
2222: NULL corrected_quantity,
2223: DECODE( tax_dist.related_id, NULL, NULL,
2224: tax_dist.invoice_distribution_id,
2225: ap_invoice_distributions_s.CURRVAL, NULL) related_id,
2226:
2227: NULL asset_book_type_code,
2228: NULL asset_category_id,
2229: tax_dist.distribution_class distribution_class,

Line 2403: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,

2399: tax_dist.award_id) award_id,
2400: NULL credit_card_trx_id,
2401: tax_dist.dist_match_type dist_match_type,
2402: tax_dist.rcv_transaction_id rcv_transaction_id,
2403: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,
2404: tax_dist.invoice_distribution_id parent_reversal_id,
2405: tax_dist.tax_recoverable_flag tax_recoverable_flag,
2406: NULL merchant_document_number,
2407: NULL merchant_name,

Line 2432: ap_invoice_distributions_s.CURRVAL, NULL) related_id,

2428: zx_dist.trx_line_dist_id charge_applicable_to_dist_id,
2429: NULL corrected_quantity,
2430: DECODE( tax_dist.related_id, NULL, NULL,
2431: tax_dist.invoice_distribution_id,
2432: ap_invoice_distributions_s.CURRVAL, NULL) related_id,
2433:
2434: NULL asset_book_type_code,
2435: NULL asset_category_id,
2436: tax_dist.distribution_class distribution_class,

Line 4407: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

4403: (SELECT
4404: Invoice_Id, -- invoice_id
4405: Invoice_Line_Number, -- invoice_line_number
4406: Dist_Code_Combination_Id, -- dist_code_combination_id
4407: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
4408: sysdate, -- last_update_date
4409: p_Last_Updated_By, -- last_updated_by
4410: /* Bug 5584997, Getting the accounting_date from line rec
4411: --Bug9345786. Commented the following code.

Line 4566: ap_invoice_distributions_s.CURRVAL,

4562: charge_applicable_to_dist_id, -- charge_applicable_to_dist_id
4563: corrected_invoice_dist_id, -- corrected_invoice_dist_id
4564: DECODE( related_id, NULL, NULL,
4565: invoice_distribution_id,
4566: ap_invoice_distributions_s.CURRVAL,
4567: --bugfix:4921399
4568: NULL ), -- related_id
4569: asset_book_type_code, -- asset_book_type_code
4570: asset_category_id, -- asset_category_id

Line 5274: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

5270: (SELECT
5271: Invoice_Id, -- invoice_id
5272: Invoice_Line_Number, -- invoice_line_number
5273: Dist_Code_Combination_Id, -- dist_code_combination_id
5274: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
5275: sysdate, -- last_update_date
5276: fnd_global.user_id, -- last_updated_by
5277: /* Bug 5584997, Getting the accounting_date from line rec */
5278: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_inv_line_rec.accounting_date,

Line 5413: ap_invoice_distributions_s.CURRVAL,

5409: charge_applicable_to_dist_id, -- charge_applicable_to_dist_id
5410: corrected_invoice_dist_id, -- corrected_invoice_dist_id
5411: DECODE( related_id, NULL, NULL,
5412: invoice_distribution_id,
5413: ap_invoice_distributions_s.CURRVAL,
5414: --bugfix:4921399
5415: NULL ), -- related_id
5416: asset_book_type_code, -- asset_book_type_code
5417: asset_category_id, -- asset_category_id