DBA Data[Home] [Help]

APPS.OKC_OC_INT_KTQ_PVT dependencies on OKC_RULES_B

Line 495: ,okc_rules_b rul

491: rul.jtot_object3_code,
492: rul.rule_information_category
493: FROM
494: okc_rule_groups_b rgp
495: ,okc_rules_b rul
496: -- ,okc_rg_party_roles rpr
497: WHERE
498: -- Since only one party is allowed in a contract, the party who is acting
499: -- as the subject or object of a rule group is not handled

Line 632: object1_id1 okc_rules_b.object1_id1%TYPE

628: TYPE rule_rec_typ IS RECORD
629: (
630: chr_id okc_k_headers_b.id%TYPE,
631: cle_id okc_k_lines_b.id%TYPE,
632: object1_id1 okc_rules_b.object1_id1%TYPE
633: ,object1_id2 okc_rules_b.object1_id2%TYPE
634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
635: ,object2_id1 okc_rules_b.object2_id1%TYPE
636: ,object2_id2 okc_rules_b.object2_id2%TYPE

Line 633: ,object1_id2 okc_rules_b.object1_id2%TYPE

629: (
630: chr_id okc_k_headers_b.id%TYPE,
631: cle_id okc_k_lines_b.id%TYPE,
632: object1_id1 okc_rules_b.object1_id1%TYPE
633: ,object1_id2 okc_rules_b.object1_id2%TYPE
634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
635: ,object2_id1 okc_rules_b.object2_id1%TYPE
636: ,object2_id2 okc_rules_b.object2_id2%TYPE
637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE

Line 634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE

630: chr_id okc_k_headers_b.id%TYPE,
631: cle_id okc_k_lines_b.id%TYPE,
632: object1_id1 okc_rules_b.object1_id1%TYPE
633: ,object1_id2 okc_rules_b.object1_id2%TYPE
634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
635: ,object2_id1 okc_rules_b.object2_id1%TYPE
636: ,object2_id2 okc_rules_b.object2_id2%TYPE
637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
638: ,object3_id1 okc_rules_b.object3_id1%TYPE

Line 635: ,object2_id1 okc_rules_b.object2_id1%TYPE

631: cle_id okc_k_lines_b.id%TYPE,
632: object1_id1 okc_rules_b.object1_id1%TYPE
633: ,object1_id2 okc_rules_b.object1_id2%TYPE
634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
635: ,object2_id1 okc_rules_b.object2_id1%TYPE
636: ,object2_id2 okc_rules_b.object2_id2%TYPE
637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
638: ,object3_id1 okc_rules_b.object3_id1%TYPE
639: ,object3_id2 okc_rules_b.object3_id2%TYPE

Line 636: ,object2_id2 okc_rules_b.object2_id2%TYPE

632: object1_id1 okc_rules_b.object1_id1%TYPE
633: ,object1_id2 okc_rules_b.object1_id2%TYPE
634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
635: ,object2_id1 okc_rules_b.object2_id1%TYPE
636: ,object2_id2 okc_rules_b.object2_id2%TYPE
637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
638: ,object3_id1 okc_rules_b.object3_id1%TYPE
639: ,object3_id2 okc_rules_b.object3_id2%TYPE
640: ,jtot_object3_code okc_rules_b.jtot_object3_code%TYPE

Line 637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE

633: ,object1_id2 okc_rules_b.object1_id2%TYPE
634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
635: ,object2_id1 okc_rules_b.object2_id1%TYPE
636: ,object2_id2 okc_rules_b.object2_id2%TYPE
637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
638: ,object3_id1 okc_rules_b.object3_id1%TYPE
639: ,object3_id2 okc_rules_b.object3_id2%TYPE
640: ,jtot_object3_code okc_rules_b.jtot_object3_code%TYPE
641: ,rule_information_category okc_rules_b.rule_information_category%TYPE

Line 638: ,object3_id1 okc_rules_b.object3_id1%TYPE

634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
635: ,object2_id1 okc_rules_b.object2_id1%TYPE
636: ,object2_id2 okc_rules_b.object2_id2%TYPE
637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
638: ,object3_id1 okc_rules_b.object3_id1%TYPE
639: ,object3_id2 okc_rules_b.object3_id2%TYPE
640: ,jtot_object3_code okc_rules_b.jtot_object3_code%TYPE
641: ,rule_information_category okc_rules_b.rule_information_category%TYPE
642: );

Line 639: ,object3_id2 okc_rules_b.object3_id2%TYPE

635: ,object2_id1 okc_rules_b.object2_id1%TYPE
636: ,object2_id2 okc_rules_b.object2_id2%TYPE
637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
638: ,object3_id1 okc_rules_b.object3_id1%TYPE
639: ,object3_id2 okc_rules_b.object3_id2%TYPE
640: ,jtot_object3_code okc_rules_b.jtot_object3_code%TYPE
641: ,rule_information_category okc_rules_b.rule_information_category%TYPE
642: );
643:

Line 640: ,jtot_object3_code okc_rules_b.jtot_object3_code%TYPE

636: ,object2_id2 okc_rules_b.object2_id2%TYPE
637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
638: ,object3_id1 okc_rules_b.object3_id1%TYPE
639: ,object3_id2 okc_rules_b.object3_id2%TYPE
640: ,jtot_object3_code okc_rules_b.jtot_object3_code%TYPE
641: ,rule_information_category okc_rules_b.rule_information_category%TYPE
642: );
643:
644: TYPE rule_tbl_typ IS TABLE OF rule_rec_typ INDEX BY BINARY_INTEGER;

Line 641: ,rule_information_category okc_rules_b.rule_information_category%TYPE

637: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
638: ,object3_id1 okc_rules_b.object3_id1%TYPE
639: ,object3_id2 okc_rules_b.object3_id2%TYPE
640: ,jtot_object3_code okc_rules_b.jtot_object3_code%TYPE
641: ,rule_information_category okc_rules_b.rule_information_category%TYPE
642: );
643:
644: TYPE rule_tbl_typ IS TABLE OF rule_rec_typ INDEX BY BINARY_INTEGER;
645: