APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_ORDER_TYPES_V

Line 1878: FROM oe_order_types_v

1874: begin
1875: /*7194250
1876: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
1877: INTO l_credit_check_rule_id
1878: FROM oe_order_types_v
1879: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
1880: 7194250*/
1881: --7194250
1882: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)

Line 1884: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

1880: 7194250*/
1881: --7194250
1882: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
1883: INTO l_credit_check_rule_id
1884: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
1885: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
1886: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
1887: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1888: --7194250

Line 1912: FROM OE_ORDER_TYPES_V

1908: begin
1909: /*7194250
1910: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
1911: INTO l_credit_check_rule_id
1912: FROM OE_ORDER_TYPES_V
1913: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
1914: 7194250*/
1915: --7194250
1916: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)

Line 1918: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

1914: 7194250*/
1915: --7194250
1916: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
1917: INTO l_credit_check_rule_id
1918: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
1919: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
1920: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
1921: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1922: --7194250

Line 1943: FROM OE_ORDER_TYPES_V

1939: begin
1940: /*7194250
1941: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)
1942: INTO l_credit_check_rule_id
1943: FROM OE_ORDER_TYPES_V
1944: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
1945: 7194250*/
1946: --7194250
1947: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)

Line 1949: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

1945: 7194250*/
1946: --7194250
1947: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)
1948: INTO l_credit_check_rule_id
1949: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
1950: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
1951: AND PACKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
1952: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1953: --7194250

Line 1974: FROM OE_ORDER_TYPES_V

1970: begin
1971: /*7194250
1972: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)
1973: INTO l_credit_check_rule_id
1974: FROM OE_ORDER_TYPES_V
1975: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id;
1976: 7194250*/
1977: --7194250
1978: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)

Line 1980: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

1976: 7194250*/
1977: --7194250
1978: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)
1979: INTO l_credit_check_rule_id
1980: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
1981: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
1982: AND PICKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
1983: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1984: --7194250