DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on PO_LOOKUP_CODES

Line 1169: FROM po_lookup_codes plu

1165: /* Upgrade old AP transactions */
1166:
1167: Select plu.displayed_field
1168: into l_old_ipv
1169: FROM po_lookup_codes plu
1170: WHERE plu.lookup_type = 'ACCRUAL TYPE'
1171: AND plu.lookup_code = 'AP INVOICE PRICE VAR';
1172:
1173: l_stmt_num := 30;

Line 1179: FROM po_lookup_codes plu

1175: debug(' l_old_ipv :'||l_old_ipv);
1176:
1177: Select plu.displayed_field
1178: into l_old_erv
1179: FROM po_lookup_codes plu
1180: WHERE plu.lookup_type = 'ACCRUAL TYPE'
1181: AND plu.lookup_code = 'AP EXCHANGE RATE VAR';
1182:
1183: l_stmt_num := 40;

Line 2051: po_lookup_codes plc,

2047: ,xld.ae_line_num
2048: --}
2049: FROM cst_write_offs cwo,
2050: po_accrual_write_offs_all pawo,
2051: po_lookup_codes plc,
2052: rcv_receiving_sub_ledger rrs,
2053: rcv_transactions rt,
2054: xla_distribution_links xld,
2055: cst_accrual_accounts ca --BUG#7528609

Line 2144: po_lookup_codes plc,

2140: ,MAX(xld.ae_line_num)
2141: --}
2142: FROM cst_write_offs cwo,
2143: po_accrual_write_offs_all pawo,
2144: po_lookup_codes plc,
2145: ap_invoice_distributions_all aida,
2146: ap_ae_lines_all aal,
2147: cst_accrual_accounts ca, --BUG#7528609
2148: xla_distribution_links xld