DBA Data[Home] [Help]

APPS.OKE_FORM_DD250 dependencies on OKC_K_PARTY_ROLES_B

Line 681: FROM okc_k_party_roles_b pr

677: SELECT pr.jtot_object1_code Object_Code
678: , pr.object1_id1 ID1
679: , pr.code
680: , pr.facility
681: FROM okc_k_party_roles_b pr
682: , oke_k_deliverables_b kd
683: , ( select cle_id , cle_id_ascendant , level_sequence
684: from okc_ancestrys
685: union all

Line 705: FROM okc_k_party_roles_b pr

701: ( C_Deliverable_ID NUMBER
702: , C_Party_ID VARCHAR2
703: , C_Role_Code VARCHAR2 ) IS
704: SELECT pr.code
705: FROM okc_k_party_roles_b pr
706: , oke_k_deliverables_b kd
707: , ( select cle_id , cle_id_ascendant , level_sequence
708: from okc_ancestrys
709: union all

Line 732: FROM okc_k_party_roles_b pr

728: , C_ID1 NUMBER ) IS
729: SELECT pr.jtot_object1_code Object_Code
730: , pr.object1_id1 ID1
731: , pr.facility
732: FROM okc_k_party_roles_b pr
733: , oke_k_deliverables_b kd
734: , ( select cle_id , cle_id_ascendant , level_sequence
735: from okc_ancestrys
736: union all

Line 756: FROM okc_k_party_roles_b pr

752: ( C_Deliverable_ID NUMBER
753: , C_Role_Code VARCHAR2
754: , C_ID1 NUMBER ) IS
755: SELECT pr.code
756: FROM okc_k_party_roles_b pr
757: , oke_k_deliverables_b kd
758: , ( select cle_id , cle_id_ascendant , level_sequence
759: from okc_ancestrys
760: union all

Line 806: FROM okc_k_party_roles_b

802: CURSOR ShipFrom
803: ( C_K_Header_ID NUMBER
804: , C_Ship_From_Org NUMBER ) IS
805: SELECT Code
806: FROM okc_k_party_roles_b
807: WHERE rle_code = 'SHIP_FROM'
808: AND jtot_object1_code = 'OKX_INVENTORY'
809: AND object1_id1 = C_Ship_From_Org
810: AND dnz_chr_id = C_K_Header_ID;