APPS.OKS_IB_UTIL_PVT dependencies on OKC_STATUSES_B

Line 1432: , OKC_STATUSES_B ST

1428:
1429: From OKC_K_ITEMS KI
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

Line 1436: ,OKC_STATUSES_B HST

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)
1440: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 1487: , OKC_STATUSES_B ST

1483: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, Kl.end_date)
1484: From OKC_K_ITEMS KI
1485: , OKC_K_HEADERS_ALL_B KH
1486: , OKC_K_LINES_B KL
1487: , OKC_STATUSES_B ST
1488: , Oks_Instance_k_dtls_temp tmp
1489: , OKC_STATUSES_B HST
1490: Where tmp.parent_id = p_batch_id
1491: And KI.Object1_id1 = to_char(tmp.instance_id)

Line 1489: , OKC_STATUSES_B HST

1485: , OKC_K_HEADERS_ALL_B KH
1486: , OKC_K_LINES_B KL
1487: , OKC_STATUSES_B ST
1488: , Oks_Instance_k_dtls_temp tmp
1489: , OKC_STATUSES_B HST
1490: Where tmp.parent_id = p_batch_id
1491: And KI.Object1_id1 = to_char(tmp.instance_id)
1492: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'
1493: And KI.dnz_chr_id = KH.ID

Line 1539: ,OKC_STATUSES_B ST

1535: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, Kl.end_date)
1536: From OKC_K_ITEMS KI
1537: ,OKC_K_HEADERS_ALL_B KH
1538: ,OKC_K_LINES_B KL
1539: ,OKC_STATUSES_B ST
1540: ,csi_counter_associations ctrAsc
1541: , Oks_Instance_k_dtls_temp tmp
1542: , OKC_STATUSES_B HST
1543:

Line 1542: , OKC_STATUSES_B HST

1538: ,OKC_K_LINES_B KL
1539: ,OKC_STATUSES_B ST
1540: ,csi_counter_associations ctrAsc
1541: , Oks_Instance_k_dtls_temp tmp
1542: , OKC_STATUSES_B HST
1543:
1544: Where tmp.parent_id = p_batch_id
1545: And KI.object1_id1 = to_char(ctrAsc.Counter_id)
1546: And ctrAsc.source_object_id = tmp.instance_id

Line 1593: , OKC_STATUSES_B ST

1589: , null
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