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 448: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 477: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

473: --7194250
474: BEGIN --7695423
475: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
476: INTO l_credit_check_rule_id
477: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
478: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
479: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
480: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
481: --7695423 start

Line 748: FROM OE_CREDIT_CHECK_RULES

744: , DECODE(SHIPPING_INTERVAL, NULL,
745: TO_DATE('31/12/4712', 'DD/MM/YYYY'),
746: SHIPPING_INTERVAL+SYSDATE)
747: , INCLUDE_PAYMENTS_AT_RISK_FLAG
748: FROM OE_CREDIT_CHECK_RULES
749: WHERE CREDIT_CHECK_RULE_ID = p_credit_check_rule_id;
750:
751: Cursor ar_balance IS
752: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)

Line 1676: from OE_CREDIT_CHECK_RULES

1672: p_check_past_due := 'N';
1673:
1674: select NVL(maximum_days_past_due, 0)
1675: into l_maximum_days_past_due
1676: from OE_CREDIT_CHECK_RULES
1677: where CREDIT_CHECK_RULE_ID = p_credit_rule_id;
1678:
1679: if l_maximum_days_past_due > 0 then
1680: -- Check to see if there is any unpaid invoice that is past the

Line 1762: from OE_CREDIT_CHECK_RULES

1758: /* If the value of include_tax_flag is NULL that means it is 'No' */
1759:
1760: select NVL(include_tax_flag, 'N')
1761: into l_include_tax_flag
1762: from OE_CREDIT_CHECK_RULES
1763: where CREDIT_CHECK_RULE_ID = p_credit_rule_id;
1764:
1765: -- Total order limit of the site should be compared against
1766: -- the sum of all the lines that has this site

Line 2140: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

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

Line 2166: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2162: --7194250
2163: BEGIN --7695423
2164: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
2165: INTO l_credit_check_rule_id
2166: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2167: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2168: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2169: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2170: --7695423 start

Line 2429: FROM OE_CREDIT_CHECK_RULES

2425: , DECODE(SHIPPING_INTERVAL, NULL,
2426: TO_DATE('31/12/4712', 'DD/MM/YYYY'),
2427: SHIPPING_INTERVAL+SYSDATE)
2428: , INCLUDE_PAYMENTS_AT_RISK_FLAG
2429: FROM OE_CREDIT_CHECK_RULES
2430: WHERE CREDIT_CHECK_RULE_ID = p_credit_check_rule_id;
2431:
2432: Cursor ar_balance IS
2433: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)