APPS.OE_CREDIT_PUB dependencies on OE_CREDIT_CHECK_RULES

Line 28: from OE_CREDIT_CHECK_RULES

24: p_check_past_due := 'N';
25:
26: select NVL(maximum_days_past_due, 0)
27: into l_maximum_days_past_due
28: from OE_CREDIT_CHECK_RULES
29: where CREDIT_CHECK_RULE_ID = p_credit_rule_id;
30:
31: if l_maximum_days_past_due > 0 then
32: -- Check to see if there is any unpaid invoice that is past the

Line 122: from OE_CREDIT_CHECK_RULES

118: /* If the value of include_tax_flag is NULL that means it is 'No' */
119:
120: select NVL(include_tax_flag, 'N')
121: into l_include_tax_flag
122: from OE_CREDIT_CHECK_RULES
123: where CREDIT_CHECK_RULE_ID = p_credit_rule_id;
124:
125: -- Depending on the value of tax_flag add the tax_value
126:

Line 447: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

443: 7194250*/
444: --7194250
445: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
446: INTO l_credit_check_rule_id
447: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
448: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
449: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
450: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
451: --7194250

Line 468: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

464: 7194250*/
465: --7194250
466: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
467: INTO l_credit_check_rule_id
468: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
469: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
470: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
471: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
472: --7194250

Line 730: FROM OE_CREDIT_CHECK_RULES

726: , DECODE(SHIPPING_INTERVAL, NULL,
727: TO_DATE('31/12/4712', 'DD/MM/YYYY'),
728: SHIPPING_INTERVAL+SYSDATE)
729: , INCLUDE_PAYMENTS_AT_RISK_FLAG
730: FROM OE_CREDIT_CHECK_RULES
731: WHERE CREDIT_CHECK_RULE_ID = p_credit_check_rule_id;
732:
733: Cursor ar_balance IS
734: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)

Line 1658: from OE_CREDIT_CHECK_RULES

1654: p_check_past_due := 'N';
1655:
1656: select NVL(maximum_days_past_due, 0)
1657: into l_maximum_days_past_due
1658: from OE_CREDIT_CHECK_RULES
1659: where CREDIT_CHECK_RULE_ID = p_credit_rule_id;
1660:
1661: if l_maximum_days_past_due > 0 then
1662: -- Check to see if there is any unpaid invoice that is past the

Line 1744: from OE_CREDIT_CHECK_RULES

1740: /* If the value of include_tax_flag is NULL that means it is 'No' */
1741:
1742: select NVL(include_tax_flag, 'N')
1743: into l_include_tax_flag
1744: from OE_CREDIT_CHECK_RULES
1745: where CREDIT_CHECK_RULE_ID = p_credit_rule_id;
1746:
1747: -- Total order limit of the site should be compared against
1748: -- the sum of all the lines that has this site

Line 2121: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2117: 7194250*/
2118: --7194250
2119: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
2120: INTO l_credit_check_rule_id
2121: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2122: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2123: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2124: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2125: --7194250

Line 2139: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2135: 7194250*/
2136: --7194250
2137: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
2138: INTO l_credit_check_rule_id
2139: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2140: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2141: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2142: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2143: --7194250

Line 2393: FROM OE_CREDIT_CHECK_RULES

2389: , DECODE(SHIPPING_INTERVAL, NULL,
2390: TO_DATE('31/12/4712', 'DD/MM/YYYY'),
2391: SHIPPING_INTERVAL+SYSDATE)
2392: , INCLUDE_PAYMENTS_AT_RISK_FLAG
2393: FROM OE_CREDIT_CHECK_RULES
2394: WHERE CREDIT_CHECK_RULE_ID = p_credit_check_rule_id;
2395:
2396: Cursor ar_balance IS
2397: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)