APPS.OE_BULK_CACHE dependencies on OE_TRANSACTION_TYPES_ALL

Line 228: FROM oe_transaction_types_all o

224: ,G_ORDER_TYPE_TBL(p_key).default_attributes
225: ,G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag
226: ,G_ORDER_TYPE_TBL(p_key).tax_calculation_flag
227: ,G_ORDER_TYPE_TBL(p_key).cust_trx_type_id
228: FROM oe_transaction_types_all o
229: ,oe_transaction_types_tl otl
230: ,oe_ra_rules_v i
231: ,oe_ra_rules_v a
232: ,qp_list_headers_vl pl

Line 238: ,oe_transaction_types_all lt

234: ,oe_ship_methods_v sm
235: ,oe_ar_lookups_v fp
236: ,oe_lookups ft
237: ,oe_fnd_common_lookups_v dc
238: ,oe_transaction_types_all lt
239: ,oe_credit_check_rules rl
240: ,ra_cust_trx_types rtrx
241: WHERE o.transaction_type_id = p_key
242: AND o.invoicing_rule_id = i.rule_id(+)

Line 318: FROM OE_TRANSACTION_TYPES_ALL o

314: ,G_ORDER_TYPE_TBL(p_key).scheduling_level_code
315: ,G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag
316: ,G_ORDER_TYPE_TBL(p_key).tax_calculation_flag
317: ,G_ORDER_TYPE_TBL(p_key).cust_trx_type_id
318: FROM OE_TRANSACTION_TYPES_ALL o
319: ,oe_transaction_types_tl otl
320: ,oe_credit_check_rules rl
321: ,ra_cust_trx_types rtrx
322: WHERE o.transaction_type_id = p_key

Line 412: FROM oe_transaction_types_all o

408: ,G_LINE_TYPE_TBL(p_key).end_date_active
409: ,G_LINE_TYPE_TBL(p_key).cust_trx_type_id
410: ,G_LINE_TYPE_TBL(p_key).tax_calculation_flag
411: ,G_LINE_TYPE_TBL(p_key).scheduling_level_code
412: FROM oe_transaction_types_all o
413: ,ra_cust_trx_types ct
414: WHERE o.transaction_type_id = p_key
415: AND o.cust_trx_type_id = ct.cust_trx_type_id(+);
416:

Line 959: ,oe_transaction_types_all o

955: ,G_SHIP_TO_TBL(MOD(p_key,G_BINARY_LIMIT)).demand_class_code
956: ,G_SHIP_TO_TBL(MOD(p_key,G_BINARY_LIMIT)).default_attributes
957: FROM hz_cust_site_uses_all s
958: ,hz_cust_acct_sites_all a -- changed to _all since we know site_use_id and to perform better.
959: ,oe_transaction_types_all o
960: ,oe_ship_methods_v sm
961: ,oe_ar_lookups_v fp
962: ,oe_lookups ft
963: ,oe_fnd_common_lookups_v dc

Line 1604: ,oe_transaction_types_all o

1600: ,G_INVOICE_TO_TBL(MOD(p_key,G_BINARY_LIMIT)).price_list_id
1601: ,G_INVOICE_TO_TBL(MOD(p_key,G_BINARY_LIMIT)).default_attributes
1602: FROM hz_cust_site_uses_all s
1603: ,hz_cust_acct_sites a
1604: ,oe_transaction_types_all o
1605: ,ra_terms_b term
1606: ,qp_list_headers_b pl
1607: WHERE s.site_use_id = p_key
1608: AND s.site_use_code = 'BILL_TO'

Line 1752: ,oe_transaction_types_all o

1748: ,G_SOLD_TO_SITE_TBL(MOD(p_key,G_BINARY_LIMIT)).price_list_id
1749: ,G_SOLD_TO_SITE_TBL(MOD(p_key,G_BINARY_LIMIT)).default_attributes
1750: FROM hz_cust_site_uses_all s
1751: ,hz_cust_acct_sites a
1752: ,oe_transaction_types_all o
1753: ,ra_terms_b term
1754: ,qp_list_headers_b pl
1755: WHERE s.site_use_id = p_key
1756: AND s.site_use_code = 'SOLD_TO'