288: inv.TERMS_SEQUENCE_NUMBER
289: FROM
290: LNS_OPEN_RECEIVABLES_V inv,
291: FUN_RULE_BULK_RESULT_GT results,
292: FUN_RULE_DETAILS rules
293: WHERE inv.payment_schedule_id = results.id
294: AND rules.RULE_DETAIL_ID = results.RULE_DETAIL_ID
295: AND results.RULE_DETAIL_ID <> -99
296: ORDER BY rules.SEQ, pSortAttribute;
296: ORDER BY rules.SEQ, pSortAttribute;
297:
298: /* -- pSortAttribute
299: (select DEFAULT_VALUE from
300: FUN_RULE_OBJ_ATTRIBUTES attr, FUN_RULE_DETAILS rule, FUN_RULE_BULK_RESULT_GT gt
301: where attr.RULE_OBJECT_ID = rule.rule_object_id
302: and rule.rule_detail_id = gt.rule_detail_id
303: and rownum < 2);
304: */