DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on PO_DISTRIBUTIONS

Line 617: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';

613: p_retainage_withheld_amt => NULL,
614: p_retainage_released_amt => NULL
615: );
616:
617: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
618: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
620: END IF;
621:

Line 1292: po_distributions.line_location_id%TYPE;

1288: ap_invoice_distributions.tax_recoverable_flag%TYPE;
1289: l_po_distribution_id
1290: ap_invoice_distributions.po_distribution_id%TYPE;
1291: l_line_location_id
1292: po_distributions.line_location_id%TYPE;
1293: l_accrue_on_receipt
1294: po_distributions.accrue_on_receipt_flag%TYPE;
1295: l_dist_count NUMBER;
1296: l_user_id NUMBER;

Line 1294: po_distributions.accrue_on_receipt_flag%TYPE;

1290: ap_invoice_distributions.po_distribution_id%TYPE;
1291: l_line_location_id
1292: po_distributions.line_location_id%TYPE;
1293: l_accrue_on_receipt
1294: po_distributions.accrue_on_receipt_flag%TYPE;
1295: l_dist_count NUMBER;
1296: l_user_id NUMBER;
1297: l_dist_attribute_category
1298: ap_invoice_distributions.attribute_category%TYPE;

Line 1446: po_distributions PD,

1442: gsob.chart_of_accounts_id
1443: FROM ap_invoice_distributions AID,
1444: ap_invoices AI,
1445: ap_suppliers PV,
1446: po_distributions PD,
1447: ap_system_parameters ap,
1448: gl_sets_of_books gsob
1449: WHERE AI.invoice_id = X_invoice_id
1450: AND AID.invoice_id = AI.invoice_id

Line 6081: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;

6077: X_default_dist_ccid IN AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE) --bug 5386396
6078: RETURN BOOLEAN
6079: IS
6080:
6081: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;
6082: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;
6083: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
6084: l_dist_code_concat VARCHAR2(2000);
6085: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

Line 6082: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;

6078: RETURN BOOLEAN
6079: IS
6080:
6081: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;
6082: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;
6083: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
6084: l_dist_code_concat VARCHAR2(2000);
6085: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
6086: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

Line 6443: FROM po_distributions

6439: SELECT code_combination_id,
6440: accrue_on_receipt_flag
6441: INTO l_po_ccid,
6442: l_po_accrue_on_receipt_flag
6443: FROM po_distributions
6444: WHERE po_distribution_id = X_item_po_dist_id;
6445:
6446: EXCEPTION
6447: When no_data_found then

Line 8347: po_distributions PD,

8343: ail.line_source --Bug#10416960
8344: FROM ap_invoices_all AI,
8345: ap_system_parameters_all ASP,
8346: ap_invoice_distributions D,
8347: po_distributions PD,
8348: po_lines PL,
8349: po_line_types PLT, -- Amount Based Matching
8350: po_line_locations PLL,
8351: rcv_transactions RTXN,

Line 8420: po_distributions PD,

8416: ap_invoices retain_ai, --bug 9242891 retained invoice
8417: ap_system_parameters_all ASP,
8418: ap_invoice_distributions D,
8419: ap_invoice_distributions retain_d, --bug 9242891 retainage inv dists
8420: po_distributions PD,
8421: po_lines PL,
8422: po_line_types PLT, -- Amount Based Matching
8423: po_line_locations PLL,
8424: rcv_transactions RTXN,