70: drv.next_inv_seq,
71: drv.disb_rule_vendor_site_id
72: from okl_disb_rules_all_b dra,
73: okl_disb_rule_vendor_sites drv,
74: okl_disb_rule_sty_types drs
75: where drv.disb_rule_id = dra.disb_rule_id
76: and drs.disb_rule_id = dra.disb_rule_id
77: and drv.vendor_id = p_vendor_id
78: and drv.vendor_site_id = p_vendor_site_id
1116: drv.disb_rule_vendor_site_id,
1117: drv.disb_rule_id
1118: from okl_disb_rules_all_b dra,
1119: okl_disb_rule_vendor_sites drv,
1120: okl_disb_rule_sty_types drs
1121: where drv.DISB_RULE_ID = dra.disb_rule_id
1122: and drs.disb_rule_id = dra.disb_rule_id
1123: and drv.vendor_id = vId
1124: and drv.vendor_site_id = vSiteid