[Home] [Help]
584: , L.Line_Description Line_Description
585: , L.Comments Line_Comments
586: , nvl( D.Unit_Price , L.Unit_Price ) Unit_Price
587: , nvl( D.UOM_Code , L.UOM_Code ) UOM_Code
588: FROM oke_k_deliverables_b D
589: , oke_k_lines_v L
590: , mtl_item_flexfields I
591: WHERE D.Deliverable_ID = C_Deliverable_ID
592: AND L.K_Line_ID = D.K_Line_ID
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
686: select id , id , 99999 from okc_k_lines_b ) a
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
710: select id , id , 99999 from okc_k_lines_b ) a
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
737: select id , id , 99999 from okc_k_lines_b ) a
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
761: select id , id , 99999 from okc_k_lines_b ) a
779: , OKE_UTILS.Get_Term_Values
780: ( kt.term_code , kt.term_value_pk1
781: , kt.term_value_pk2 , 'MEANING' ) Name
782: FROM oke_k_terms kt
783: , oke_k_deliverables_b kd
784: , ( select cle_id , cle_id_ascendant , level_sequence
785: from okc_ancestrys
786: union all
787: select id , id , 99999 from okc_k_lines_b ) a