DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on OKS_K_LINES_B

Line 462: ,oks_k_lines_b Ks

458: Kh.period_type
459:
460: FROM okc_k_lines_b Kl
461: ,Oks_k_headers_b Kh
462: ,oks_k_lines_b Ks
463:
464: WHERE Kl.ID = p_line_id
465: And Ks.cle_id = Kl.Id
466: And Kh.chr_id = kl.dnz_chr_id

Line 1434: , OKS_K_LINES_B KS

1430: , OKC_K_HEADERS_all_B KH
1431: , OKC_K_LINES_B KL
1432: , OKC_STATUSES_B ST
1433: , Oks_Instance_k_dtls_temp tmp
1434: , OKS_K_LINES_B KS
1435: , OKS_K_LINES_B KS1
1436: ,OKC_STATUSES_B HST
1437:
1438: Where tmp.parent_id = p_batch_id

Line 1435: , OKS_K_LINES_B KS1

1431: , OKC_K_LINES_B KL
1432: , OKC_STATUSES_B ST
1433: , Oks_Instance_k_dtls_temp tmp
1434: , OKS_K_LINES_B KS
1435: , OKS_K_LINES_B KS1
1436: ,OKC_STATUSES_B HST
1437:
1438: Where tmp.parent_id = p_batch_id
1439: And KI.Object1_id1 = to_char(tmp.instance_id)

Line 1594: , OKS_K_LINES_B KS

1590: From OKC_K_ITEMS_V KI
1591: , OKC_K_HEADERS_ALL_B KH
1592: , OKC_K_LINES_B KL
1593: , OKC_STATUSES_B ST
1594: , OKS_K_LINES_B KS
1595: , Oks_k_lines_b KS1
1596: , Oks_Instance_k_dtls_temp tmp
1597: Where tmp.parent_id = p_batch_id
1598: And KI.Object1_id1 = to_char(tmp.instance_id)

Line 1595: , Oks_k_lines_b KS1

1591: , OKC_K_HEADERS_ALL_B KH
1592: , OKC_K_LINES_B KL
1593: , OKC_STATUSES_B ST
1594: , OKS_K_LINES_B KS
1595: , Oks_k_lines_b KS1
1596: , Oks_Instance_k_dtls_temp tmp
1597: Where tmp.parent_id = p_batch_id
1598: And KI.Object1_id1 = to_char(tmp.instance_id)
1599: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 2245: oks_k_lines_b tls,

2241: SELECT csi.OWNER_PARTY_ID old_party_id,
2242: tls1.TRANSFER_OPTION transfer_option
2243:
2244: FROM okc_k_lines_b sl,
2245: oks_k_lines_b tls,
2246: oks_k_lines_b tls1,
2247: okc_k_items im,
2248: csi_item_instances csi
2249:

Line 2246: oks_k_lines_b tls1,

2242: tls1.TRANSFER_OPTION transfer_option
2243:
2244: FROM okc_k_lines_b sl,
2245: oks_k_lines_b tls,
2246: oks_k_lines_b tls1,
2247: okc_k_items im,
2248: csi_item_instances csi
2249:
2250: WHERE sl.id = p_line_id