APPS.OE_BULK_CACHE dependencies on OE_TRANSACTION_TYPES_ALL

Line 227: FROM oe_transaction_types_all o

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

Line 237: ,oe_transaction_types_all lt

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

Line 317: FROM OE_TRANSACTION_TYPES_ALL o

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

Line 411: FROM oe_transaction_types_all o

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

Line 958: ,oe_transaction_types_all o

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

Line 1603: ,oe_transaction_types_all o

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

Line 1751: ,oe_transaction_types_all o

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