APPS.OKS_ENT_UTIL_PVT dependencies on OKC_K_HEADERS_B

Line 48: FROM OKC_K_HEADERS_B H

44: FUNCTION get_party(p_hdr_id IN Number) RETURN Varchar2
45: IS
46: CURSOR l_party_csr IS
47: SELECT P.OBJECT1_ID1
48: FROM OKC_K_HEADERS_B H
49: ,OKC_K_PARTY_ROLES_B P
50: WHERE H.ID = P.DNZ_CHR_ID
51: AND P.JTOT_OBJECT1_CODE = 'OKX_PARTY'
52: AND H.ID = p_hdr_id;

Line 90: FROM OKC_K_HEADERS_B CHR

86: */
87:
88: CURSOR l_bth_csr IS
89: SELECT CHR.BILL_TO_SITE_USE_ID,CHR.SHIP_TO_SITE_USE_ID
90: FROM OKC_K_HEADERS_B CHR
91: WHERE CHR.ID = p_hdr_id;
92:
93: CURSOR l_btl_csr IS
94: SELECT CLE.BILL_TO_SITE_USE_ID,CLE.SHIP_TO_SITE_USE_ID

Line 162: FROM OKC_K_HEADERS_B CHR

158: */
159:
160: CURSOR l_plh_csr IS
161: SELECT CHR.PRICE_LIST_ID,CHR.CURRENCY_CODE
162: FROM OKC_K_HEADERS_B CHR
163: WHERE CHR.ID = p_hdr_id;
164:
165: CURSOR l_pll_csr IS
166: SELECT CLE.PRICE_LIST_ID,CLE.CURRENCY_CODE

Line 342: FROM OKC_K_HEADERS_B CHR

338: */
339:
340: CURSOR l_invh_csr IS
341: SELECT CHR.INV_RULE_ID
342: FROM OKC_K_HEADERS_B CHR
343: WHERE CHR.ID = p_hdr_id;
344:
345: CURSOR l_invl_csr IS
346: SELECT CLE.INV_RULE_ID

Line 560: FROM OKC_K_HEADERS_B CHR

556: */
557:
558: CURSOR l_termsh_csr IS
559: SELECT CHR.PAYMENT_TERM_ID
560: FROM OKC_K_HEADERS_B CHR
561: WHERE CHR.ID = p_hdr_id;
562:
563: CURSOR l_termsl_csr IS
564: SELECT CLE.PAYMENT_TERM_ID

Line 696: FROM OKC_K_HEADERS_B HD,

692:
693: CURSOR l_sys_csr IS
694: SELECT SY.ID1,
695: SY.NAME
696: FROM OKC_K_HEADERS_B HD,
697: OKC_K_LINES_B KL,
698: OKC_K_ITEMS IT,
699: OKX_SYSTEMS_V SY
700: WHERE HD.ID = KL.DNZ_CHR_ID

Line 727: FROM OKC_K_HEADERS_B HD,

723: /*
724: CURSOR l_sys_csr IS
725: SELECT SY.ID1,
726: SY.NAME
727: FROM OKC_K_HEADERS_B HD,
728: OKC_K_LINES_B KL,
729: OKC_K_ITEMS IT,
730: -- OKC_RULE_GROUPS_B RG,
731: -- OKC_RULES_B RL,

Line 778: OKC_K_HEADERS_B H

774: V.DESCRIPTION
775: FROM OKC_K_LINES_B L,
776: OKC_K_ITEMS I,
777: OKX_SYSTEM_ITEMS_V V,
778: OKC_K_HEADERS_B H
779: WHERE L.ID = I.CLE_ID
780: AND I.OBJECT1_ID1 = V.ID1
781: AND I.OBJECT1_ID2 = V.ID2
782: AND I.JTOT_OBJECT1_CODE = 'OKX_COVITEM'

Line 808: OKC_K_HEADERS_B H

804: V.DESCRIPTION
805: FROM OKC_K_LINES_B L,
806: OKC_K_ITEMS I,
807: OKX_SYSTEM_ITEMS_V V,
808: OKC_K_HEADERS_B H
809: WHERE L.ID = I.CLE_ID
810: AND I.OBJECT1_ID1 = V.ID1
811: AND I.OBJECT1_ID2 = V.ID2
812: AND L.ID = p_line_id

Line 883: FROM OKC_K_HEADERS_B HD,

879:
880: /*
881: CURSOR l_tax_csr IS
882: SELECT object1_id1 TAX_EXEMPTION, object2_id1 TAX_STATUS
883: FROM OKC_K_HEADERS_B HD,
884: OKC_RULE_GROUPS_B RG,
885: OKC_RULES_B RL
886: WHERE HD.ID = RG.DNZ_CHR_ID
887: AND RG.ID = RL.RGP_ID

Line 922: FROM OKC_K_HEADERS_B HD,

918: IS
919: /*
920: CURSOR l_cvn_csr IS
921: SELECT object1_id1
922: FROM OKC_K_HEADERS_B HD,
923: OKC_RULE_GROUPS_B RG,
924: OKC_RULES_B RL
925: WHERE HD.ID = RG.DNZ_CHR_ID
926: AND RG.ID = RL.RGP_ID

Line 934: FROM OKC_K_HEADERS_B CHR

930: */
931:
932: CURSOR l_cvn_csr IS
933: SELECT CHR.CONVERSION_TYPE
934: FROM OKC_K_HEADERS_B CHR
935: WHERE CHR.ID = p_hdr_id;
936:
937: l_object1_id1 varchar2(40); --OKC_RULES_B.OBJECT1_ID1%TYPE;
938:

Line 953: FROM OKC_K_HEADERS_B HD,

949: FUNCTION get_agreement(p_hdr_id IN Number) RETURN Number
950: IS
951: CURSOR l_agr_csr IS
952: SELECT isa_agreement_id
953: FROM OKC_K_HEADERS_B HD,
954: OKC_GOVERNANCES GV
955: WHERE HD.ID = GV.DNZ_CHR_ID
956: AND HD.ID = p_hdr_id;
957: