APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_INSTANCE_HISTORY

Line 123: --| OKS_INSTANCE_HISTORY | X | X | | | | |

119: --| OKS_BATCH_RULES | X | | | | | |
120: --+---------------------------------+---+---+---+---+---+----------------------+
121: --| CSI_MASS_EDIT_ENTRIES_TL | X | | | | | |
122: --+---------------------------------+---+---+---+---+---+----------------------+
123: --| OKS_INSTANCE_HISTORY | X | X | | | | |
124: --+---------------------------------+---+---+---+---+---+----------------------+
125: --| OKC_QA_CHECK_PUB | | | | | |X |
126: --+---------------------------------+---+---+---+---+---+----------------------+
127: --| OKC_CONTRACT_PUB | | | | | |X |

Line 6597: oks_instance_history b

6593: (SELECT price_negotiated
6594: FROM okc_k_lines_b
6595: WHERE ID = new_subline_id)
6596: FROM oks_instance_k_dtls_temp a,
6597: oks_instance_history b
6598: WHERE b.batch_id = p_batch_id
6599: AND a.instance_id = b.instance_id
6600: AND b.transaction_type = 'TRF';
6601:

Line 7176: INSERT INTO oks_instance_history

7172: END IF;
7173: -- Insert into Instance History and Details
7174:
7175: -- Create instance History
7176: INSERT INTO oks_instance_history
7177: (ID,
7178: object_version_number,
7179: instance_id,
7180: transaction_type,

Line 7299: from oks_instance_history ins_hist,

7295: SYSDATE,
7296: fnd_global.login_id,
7297: lines_b.date_cancelled, --Date cancelled,
7298: 'TERM'
7299: from oks_instance_history ins_hist,
7300: Okc_k_lines_b lines_b,
7301: okc_k_headers_all_b hdr
7302: Where ins_hist.batch_id = p_batch_id
7303: and instance_id = custprod_id(i) and lines_b.id = subline_id (i)

Line 7702: INSERT INTO oks_instance_history

7698:
7699: -- Insert into Instance History and Details
7700: If l_instance_history_created = 'N' Then
7701: -- Create instance History
7702: INSERT INTO oks_instance_history
7703: (ID,
7704: object_version_number,
7705: instance_id,
7706: transaction_type,

Line 7819: from Oks_instance_history inshist, Okc_k_lines_b line

7815: fnd_global.user_id,
7816: SYSDATE,
7817: fnd_global.login_id,
7818: line.date_cancelled --Date cancelled
7819: from Oks_instance_history inshist, Okc_k_lines_b line
7820: ,okc_k_headers_all_b hdr
7821: Where inshist.instance_id = custprod_id(i)
7822: and batch_id = p_batch_id
7823: And line.id = subline_id(i)

Line 7921: from Oks_instance_history inshist

7917: SYSDATE,
7918: fnd_global.user_id,
7919: SYSDATE,
7920: fnd_global.login_id
7921: from Oks_instance_history inshist
7922: , okc_k_headers_all_b hdr
7923: , okc_k_lines_b line
7924: , okc_k_lines_b subline
7925: Where inshist.instance_id = custprod_id(i)

Line 8201: INSERT INTO oks_instance_history

8197:
8198:
8199: If header_id.COUNT > 0 Then
8200: -- Create instance History
8201: INSERT INTO oks_instance_history
8202: (ID,
8203: object_version_number,
8204: instance_id,
8205: transaction_type,

Line 8317: FROM oks_instance_history a, Okc_k_headers_all_b hdr

8313: fnd_global.user_id,
8314: SYSDATE,
8315: fnd_global.login_id,
8316: null
8317: FROM oks_instance_history a, Okc_k_headers_all_b hdr
8318: , okc_k_lines_b line
8319: , okc_k_lines_b subline
8320: WHERE a.batch_id = p_batch_id
8321: AND a.transaction_type = 'IDC'

Line 8536: INSERT INTO oks_instance_history

8532: RAISE g_exception_halt_validation;
8533: END IF;
8534:
8535: -- Create instance History
8536: INSERT INTO oks_instance_history
8537: (ID,
8538: object_version_number,
8539: instance_id,
8540: transaction_type,

Line 8652: FROM oks_instance_history a,

8648: fnd_global.user_id,
8649: SYSDATE,
8650: fnd_global.login_id,
8651: line.date_cancelled
8652: FROM oks_instance_history a,
8653: Okc_k_lines_b line,
8654: Okc_k_headers_all_b hdr
8655: WHERE a.batch_id = p_batch_id
8656: AND a.transaction_type = 'TRM'