[Home] [Help]
26: IS
27: ---Except Usage.
28: CURSOR l_amt_csr IS
29: SELECT SUM(L.price_negotiated)
30: FROM OKC_K_LINES_B L,
31: OKC_LINE_STYLES_B S
32: WHERE S.ID = L.LSE_ID
33: AND S.ID IN(7, 8, 9, 10, 11, 18, 25, 35)
34: AND L.DNZ_CHR_ID = NVL(p_hdr_id, L.DNZ_CHR_ID);
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
95: FROM OKC_K_LINES_B CLE
96: WHERE CLE.ID = p_line_id;
97:
98:
99: l_bt_id number ;
163: WHERE CHR.ID = p_hdr_id;
164:
165: CURSOR l_pll_csr IS
166: SELECT CLE.PRICE_LIST_ID,CLE.CURRENCY_CODE
167: FROM OKC_K_LINES_B CLE
168: WHERE CLE.ID = p_line_id;
169:
170: l_pl_id Varchar2(40);
171: l_curr_code Varchar2(15);
343: WHERE CHR.ID = p_hdr_id;
344:
345: CURSOR l_invl_csr IS
346: SELECT CLE.INV_RULE_ID
347: FROM OKC_K_LINES_B CLE
348: WHERE CLE.ID = p_line_id;
349:
350: l_inv_id Varchar2(40);
351:
561: WHERE CHR.ID = p_hdr_id;
562:
563: CURSOR l_termsl_csr IS
564: SELECT CLE.PAYMENT_TERM_ID
565: FROM OKC_K_LINES_B CLE
566: WHERE CLE.ID = p_line_id;
567:
568: l_terms_id Varchar2(40);
569:
591:
592: CURSOR l_pdt_csr IS
593: SELECT PDT.ID1,
594: PDT.QUANTITY
595: FROM OKC_K_LINES_B LIN,
596: OKC_K_ITEMS ITM,
597: OKX_CUSTOMER_PRODUCTS_V PDT
598: WHERE LIN.ID = ITM.CLE_ID
599: AND ITM.OBJECT1_ID1 = PDT.ID1
622: PDT.CUSTOMER_ID,
623: CUS.NAME,
624: PDT.INSTALL_SITE_USE_ID,
625: SIT.NAME PARTY_SITE_NAME
626: FROM OKC_K_LINES_B LIN,
627: OKC_K_ITEMS ITM,
628: OKX_CUSTOMER_PRODUCTS_V PDT,
629: OKX_CUSTOMER_ACCOUNTS_V CUS,
630: OKX_PARTIES_V PTY,
641: PDT.owner_party_account_id customer_id, --PDT.CUSTOMER_ID,
642: CUS.NAME cusname,
643: PDT.install_location_id install_location_id, --PDT.INSTALL_SITE_USE_ID,
644: SIT.NAME PARTY_SITE_NAME
645: FROM OKC_K_LINES_B LIN,
646: OKC_K_ITEMS ITM,
647: CSI_ITEM_INSTANCES PDT, --OKX_CUSTOMER_PRODUCTS_V PDT,
648: OKX_CUSTOMER_ACCOUNTS_V CUS,
649: OKX_PARTIES_V PTY,
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
701: AND KL.ID = IT.CLE_ID
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,
732: OKX_SYSTEMS_V SY
771:
772: CURSOR l_inv_csr IS
773: SELECT V.ID1,
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
801:
802: CURSOR l_inv_csr IS
803: SELECT V.ID1,
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
850: ,RQR.RULE_INFORMATION11 FIXED_UOM
851: ,TO_NUMBER(RQR.RULE_INFORMATION8) FIXED_DURATION
852: ,RQR.RULE_INFORMATION2 FIXED_PERIOD
853: ,RQR.RULE_INFORMATION9 LEVEL_FLAG
854: FROM OKC_K_LINES_B LIN,
855: OKC_RULE_GROUPS_B RGP,
856: OKC_RULES_B RQR
857: WHERE LIN.ID = RGP.CLE_ID
858: AND RGP.ID = RQR.RGP_ID
970: FUNCTION get_clvl_party(p_line_id IN Number) Return l_party_rec
971: IS
972: CURSOR l_pty_csr IS
973: SELECT IT.OBJECT1_ID1, PY.NAME
974: FROM OKC_K_LINES_B KL,
975: OKC_K_ITEMS IT,
976: OKX_PARTIES_V PY
977: WHERE KL.ID = IT.CLE_ID
978: AND IT.OBJECT1_ID1 = PY.ID1
996: FUNCTION get_clvl_customer(p_line_id IN Number) Return l_cust_rec
997: IS
998: CURSOR l_cust_csr IS
999: SELECT IT.OBJECT1_ID1, CT.NAME
1000: FROM OKC_K_LINES_B KL,
1001: OKC_K_ITEMS IT,
1002: OKX_CUSTOMER_ACCOUNTS_V CT
1003: WHERE KL.ID = IT.CLE_ID
1004: AND IT.OBJECT1_ID1 = CT.ID1
1021: FUNCTION get_clvl_site(p_line_id IN Number, p_org_id IN Number) Return l_site_rec
1022: IS
1023: CURSOR l_site_csr IS
1024: SELECT IT.OBJECT1_ID1, SI.NAME LOCATION
1025: FROM OKC_K_LINES_B KL,
1026: OKC_K_ITEMS IT,
1027: OKX_CUST_SITE_USES_V SI
1028: WHERE KL.ID = IT.CLE_ID
1029: AND IT.OBJECT1_ID1 = SI.ID1
1048: IS
1049: /*
1050: CURSOR l_cov_csr IS
1051: Select fd.meaning
1052: from okc_k_lines_b kl,
1053: okc_rule_groups_b rg,
1054: okc_rules_b rl,
1055: fnd_lookups fd
1056: where kl.id = rg.cle_id