eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_ORDER_TYPES_V

Line 1951: FROM oe_order_types_v

1947: begin
1948: /*7194250
1949: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
1950: INTO l_credit_check_rule_id
1951: FROM oe_order_types_v
1952: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
1953: 7194250*/
1954: --7194250
1955: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)

Line 1957: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

1953: 7194250*/
1954: --7194250
1955: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
1956: INTO l_credit_check_rule_id
1957: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
1958: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
1959: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
1960: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1961: --7194250

Line 1985: FROM OE_ORDER_TYPES_V

1981: begin
1982: /*7194250
1983: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
1984: INTO l_credit_check_rule_id
1985: FROM OE_ORDER_TYPES_V
1986: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
1987: 7194250*/
1988: --7194250
1989: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)

Line 1991: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

1987: 7194250*/
1988: --7194250
1989: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
1990: INTO l_credit_check_rule_id
1991: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
1992: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
1993: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
1994: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1995: --7194250

Line 2016: FROM OE_ORDER_TYPES_V

2012: begin
2013: /*7194250
2014: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)
2015: INTO l_credit_check_rule_id
2016: FROM OE_ORDER_TYPES_V
2017: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
2018: 7194250*/
2019: --7194250
2020: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)

Line 2022: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2018: 7194250*/
2019: --7194250
2020: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)
2021: INTO l_credit_check_rule_id
2022: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2023: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2024: AND PACKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2025: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2026: --7194250

Line 2047: FROM OE_ORDER_TYPES_V

2043: begin
2044: /*7194250
2045: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)
2046: INTO l_credit_check_rule_id
2047: FROM OE_ORDER_TYPES_V
2048: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
2049: 7194250*/
2050: --7194250
2051: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)

Line 2053: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2049: 7194250*/
2050: --7194250
2051: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)
2052: INTO l_credit_check_rule_id
2053: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2054: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2055: AND PICKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2056: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2057: --7194250