[Home] [Help]
1024: count(rcv_transaction_id) -- change for the bug 4968702
1025: INTO
1026: l_acq_exists
1027: FROM
1028: cst_rcv_acq_costs crac
1029: WHERE
1030: crac.rcv_transaction_id = l_par_rcv_txn AND
1031: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1032: crac.cost_group_id = i_ae_txn_rec.cost_group_id;
1043: INTO
1044: l_nqr,
1045: l_costed_quantity,
1046: l_acq_cost
1047: from cst_rcv_acq_costs crac
1048: where crac.rcv_transaction_id = l_par_rcv_txn AND
1049: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1050: crac.cost_group_id = i_ae_txn_rec.cost_group_id;
1051:
1084: aida.invoice_distribution_id = cracd.invoice_distribution_id
1085: and aia.invoice_id = aida.invoice_id
1086: and aia.org_id = aida.org_id
1087: and cracd.header_id = (select header_id
1088: from cst_rcv_acq_costs crac
1089: where rcv_transaction_id = l_par_rcv_txn
1090: AND
1091: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1092: crac.cost_group_id = i_ae_txn_rec.cost_group_id)
1107: rcv_transactions rt
1108: where
1109: poll.line_location_id = cracd.po_line_location_id
1110: and cracd.header_id = (select header_id
1111: from cst_rcv_acq_costs crac
1112: where rcv_transaction_id = rt.transaction_id
1113: AND
1114: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1115: crac.cost_group_id = i_ae_txn_rec.cost_group_id)
1465: l_dr_flag := not l_dr_flag;
1466: l_stmt_num := 1020;
1467: SELECT nvl(max(craca.period_id),-1)
1468: INTO l_lcm_adj_period
1469: FROM cst_rcv_acq_costs_adj craca
1470: WHERE craca.rcv_transaction_id = l_par_rcv_txn
1471: AND craca.cost_type_id = i_ae_txn_rec.cost_type_id
1472: AND craca.cost_group_id = i_ae_txn_rec.cost_group_id;
1473:
1474: IF (l_lcm_adj_period <> -1) THEN
1475: l_stmt_num := 1030;
1476: SELECT craca.acquisition_cost
1477: INTO l_acq_cost
1478: FROM cst_rcv_acq_costs_adj craca
1479: WHERE craca.rcv_transaction_id = l_par_rcv_txn
1480: AND craca.cost_type_id = i_ae_txn_rec.cost_type_id
1481: AND craca.cost_group_id = i_ae_txn_rec.cost_group_id
1482: AND craca.period_id = l_lcm_adj_period;
1862: aia.exchange_rate_type "EXCHANGE_RATE_TYPE",
1863: xal.code_combination_id "CODE_COMBINATION_ID"
1864: FROM
1865: cst_rcv_acq_cost_details cracd,
1866: cst_rcv_acq_costs crac,
1867: xla_distribution_links xdl,
1868: xla_ae_lines xal,
1869: xla_ae_headers xae,
1870: ap_invoice_distributions_all aida ,
1908: aia.exchange_rate_type "EXCHANGE_RATE_TYPE",
1909: aida.dist_code_combination_id "CODE_COMBINATION_ID"
1910: FROM
1911: cst_rcv_acq_cost_details cracd,
1912: cst_rcv_acq_costs crac,
1913: ap_invoice_distributions_all aida,
1914: ap_invoices_all aia
1915: WHERE
1916: cracd.line_type NOT IN ('ITEM','ACCRUAL','IPV','ERV','NONREC_TAX') AND
2044: xal.code_combination_id "CODE_COMBINATION_ID",
2045: aida.related_id "INVOICE_DISTRIBUTION_ID"
2046: FROM
2047: cst_rcv_acq_cost_details cracd,
2048: cst_rcv_acq_costs crac,
2049: xla_distribution_links xdl,
2050: xla_ae_lines xal,
2051: xla_ae_headers xae,
2052: ap_invoice_distributions_all aida,
2089: -- Need Invoice Distribution to find correction invoices
2090: aida.related_id "INVOICE_DISTRIBUTION_ID"
2091: FROM
2092: cst_rcv_acq_cost_details cracd,
2093: cst_rcv_acq_costs crac,
2094: ap_invoice_distributions_all aida,
2095: ap_invoices_all aia
2096: WHERE
2097: crac.rcv_transaction_id = l_par_rcv_txn AND
2256: xla_distribution_links xdl,
2257: xla_ae_lines xal,
2258: xla_ae_headers xae,
2259: cst_rcv_acq_cost_details cracd,
2260: cst_rcv_acq_costs crac,
2261: ap_invoice_distributions_all aida
2262: where crac.rcv_transaction_id =l_par_rcv_txn
2263: AND crac.cost_type_id=i_ae_txn_rec.cost_type_id
2264: AND crac.cost_group_id=i_ae_txn_rec.cost_group_id
2288: aida.base_amount "EXCHANGE_RATE_VARIANCE",
2289: aida.dist_code_combination_id "CODE_COMBINATION_ID"
2290: FROM
2291: cst_rcv_acq_cost_details cracd,
2292: cst_rcv_acq_costs crac,
2293: ap_invoice_distributions_all aida
2294: WHERE
2295: crac.rcv_transaction_id = l_par_rcv_txn AND
2296: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND