APPS.ONT_OEXOEIOD_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 32: OE_TRANSACTION_TYPES_TL OEOT

28: SELECT
29: OEOT.NAME
30: INTO L_ORDER_TYPE_LOW
31: FROM
32: OE_TRANSACTION_TYPES_TL OEOT
33: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
34: AND OEOT.LANGUAGE = USERENV('LANG');
35: SELECT
36: OEOT.NAME

Line 39: OE_TRANSACTION_TYPES_TL OEOT

35: SELECT
36: OEOT.NAME
37: INTO L_ORDER_TYPE_HIGH
38: FROM
39: OE_TRANSACTION_TYPES_TL OEOT
40: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
41: AND OEOT.LANGUAGE = USERENV('LANG');
42: ELSIF (P_ORDER_TYPE_LOW IS NOT NULL) THEN
43: LP_ORDER_TYPE := 'and ot.transaction_type_id >= :p_order_type_low ';

Line 48: OE_TRANSACTION_TYPES_TL OEOT

44: SELECT
45: OEOT.NAME
46: INTO L_ORDER_TYPE_LOW
47: FROM
48: OE_TRANSACTION_TYPES_TL OEOT
49: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
50: AND OEOT.LANGUAGE = USERENV('LANG');
51: ELSIF (P_ORDER_TYPE_HIGH IS NOT NULL) THEN
52: LP_ORDER_TYPE := 'and ot.transaction_type_id <= p_order_type_high ';

Line 57: OE_TRANSACTION_TYPES_TL OEOT

53: SELECT
54: OEOT.NAME
55: INTO L_ORDER_TYPE_HIGH
56: FROM
57: OE_TRANSACTION_TYPES_TL OEOT
58: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
59: AND OEOT.LANGUAGE = USERENV('LANG');
60: END IF;
61: IF (P_CUSTOMER_NAME_LOW IS NOT NULL) AND (P_CUSTOMER_NAME_HIGH IS NOT NULL) THEN

Line 819: COUNT_oe_transaction_types_tl NUMBER(10);

815: /*
816: DECLARE
817: COUNT_OE_ORDER_HEADERS NUMBER(10);
818: COUNT_oe_order_lines_all NUMBER(10);
819: COUNT_oe_transaction_types_tl NUMBER(10);
820: COUNT_hz_cust_site_uses_all NUMBER(10);
821: COUNT_hz_cust_acct_sites_all NUMBER(10);
822: COUNT_hz_party_sites NUMBER(10);
823: COUNT_hz_locations NUMBER(10);

Line 835: SELECT COUNT(*) INTO COUNT_oe_transaction_types_tl FROM oe_transaction_types_tl;

831: SELECT COUNT(*) INTO COUNT_OE_ORDER_HEADERS FROM OE_ORDER_HEADERS;
832:
833: SELECT COUNT(*) INTO COUNT_oe_order_lines_all FROM oe_order_lines_all;
834:
835: SELECT COUNT(*) INTO COUNT_oe_transaction_types_tl FROM oe_transaction_types_tl;
836:
837: SELECT COUNT(*) INTO COUNT_hz_cust_site_uses_all FROM hz_cust_site_uses_all;
838:
839: SELECT COUNT(*) INTO COUNT_hz_cust_acct_sites_all FROM hz_cust_acct_sites_all;

Line 853: DSP_COUNT:= DSP_COUNT ||' COUNT_OE_ORDER_HEADERS-->' || COUNT_OE_ORDER_HEADERS || ' COUNT_oe_order_lines_all--->' || COUNT_oe_order_lines_all ||'COUNT_oe_transaction_types_tl--->' || COUNT_oe_transaction_types_tl || 'COUNT_hz_cust_site_uses_all--->' ||

849: SELECT COUNT(*) INTO COUNT_hz_parties FROM hz_parties;
850:
851: SELECT COUNT(*) INTO COUNT_hz_cust_accounts FROM hz_cust_accounts;
852:
853: DSP_COUNT:= DSP_COUNT ||' COUNT_OE_ORDER_HEADERS-->' || COUNT_OE_ORDER_HEADERS || ' COUNT_oe_order_lines_all--->' || COUNT_oe_order_lines_all ||'COUNT_oe_transaction_types_tl--->' || COUNT_oe_transaction_types_tl || 'COUNT_hz_cust_site_uses_all--->' ||
854: COUNT_hz_cust_site_uses_all || 'COUNT_hz_cust_acct_sites_all--->' || COUNT_hz_cust_acct_sites_all || 'COUNT_hz_party_sites--->'||COUNT_hz_party_sites|| 'COUNT_hz_locations-->' ||COUNT_hz_locations||'COUNT_ra_salesreps_all-->' ||
855: COUNT_ra_salesreps_all||' COUNT_fnd_territories_vl-->'|| COUNT_fnd_territories_vl || 'COUNT_hz_parties--->' || COUNT_hz_parties||' COUNT_hz_cust_accounts-->'|| COUNT_hz_cust_accounts;
856:
857: END;*/