eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_REBOOK_CM_PVT dependencies on OKC_K_HEADERS_B

Line 82: FROM OKC_K_HEADERS_B KHR,

78: -- Get Rebooked Contracts
79: ------------------------------------------------------------
80: CURSOR rbk_ctrct_csr ( p_contract_number VARCHAR2 ) IS
81: SELECT distinct KHR.ID
82: FROM OKC_K_HEADERS_B KHR,
83: OKL_STREAMS STM,
84: OKL_STRM_TYPE_B STY,
85: OKL_STRM_ELEMENTS SEL
86: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)

Line 97: /* FROM okc_k_headers_b */

93: AND SEL.DATE_BILLED IS NULL;
94:
95:
96: /* SELECT id */
97: /* FROM okc_k_headers_b */
98: /* WHERE contract_number = NVL(p_contract_number, contract_number)
99: AND */
100: /* sts_code = 'BOOKED' AND */
101: /* id in ( */

Line 103: /* FROM okc_k_headers_b orig, */

99: AND */
100: /* sts_code = 'BOOKED' AND */
101: /* id in ( */
102: /* SELECT rebook.id */
103: /* FROM okc_k_headers_b orig, */
104: /* okc_k_headers_b rebook */
105: /* WHERE orig.contract_number = NVL(p_contract_number,
106: orig.contract_number) and */
107: /* orig.authoring_org_id =

Line 104: /* okc_k_headers_b rebook */

100: /* sts_code = 'BOOKED' AND */
101: /* id in ( */
102: /* SELECT rebook.id */
103: /* FROM okc_k_headers_b orig, */
104: /* okc_k_headers_b rebook */
105: /* WHERE orig.contract_number = NVL(p_contract_number,
106: orig.contract_number) and */
107: /* orig.authoring_org_id =
108: NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99) and */

Line 113: /* FROM okc_k_headers_b mass_rebook, */

109: /* rebook.orig_system_id1 = orig.id and */
110: /* rebook.orig_system_source_code = 'OKL_REBOOK' */
111: /* UNION */
112: /* SELECT mass_rebook.id */
113: /* FROM okc_k_headers_b mass_rebook, */
114: /* okl_rbk_selected_contract rbk */
115: /* WHERE mass_rebook.contract_number = NVL(p_contract_number,
116: mass_rebook.contract_number) and */
117: /* mass_rebook.authoring_org_id =

Line 144: okc_k_headers_b khr,

140: FROM
141: okl_strm_elements ste,
142: okl_streams stm,
143: okl_strm_type_b sty,
144: okc_k_headers_b khr,
145: okl_k_headers khl,
146: okc_k_lines_b kle,
147: okc_statuses_b khs,
148: okc_statuses_b kls

Line 206: okc_k_headers_b khr,

202: PS.class,
203: PS.TERMS_SEQUENCE_NUMBER
204: FROM
205: okl_strm_type_b sty,
206: okc_k_headers_b khr,
207: okl_k_headers khl,
208: okc_k_lines_b kle,
209: okc_statuses_b khs,
210: okc_statuses_b kls,

Line 401: l_curr_code okc_k_headers_b.currency_code%TYPE;

397:
398:
399: -- For currecy precision rounded amount
400: l_ste_amount okl_strm_elements.amount%type;
401: l_curr_code okc_k_headers_b.currency_code%TYPE;
402: ------------------------------------------------------------
403: -- For errors in Stream Elements Table
404: ------------------------------------------------------------
405:

Line 424: contract_number okc_k_headers_b.contract_number%type,

420: sel_id NUMBER,
421: tld_id NUMBER,
422: xsi_id NUMBER,
423: bill_date DATE,
424: contract_number okc_k_headers_b.contract_number%type,
425: stream_purpose okl_strm_type_v.stream_type_purpose%type,
426: amount okl_strm_elements.amount%type,
427: error_message Varchar2(2000)
428: );

Line 1059: FROM OKC_K_HEADERS_B KHR,

1055: -- Get Rebooked Contracts
1056: ------------------------------------------------------------
1057: CURSOR rbk_ctrct_csr ( p_contract_number VARCHAR2 ) IS
1058: SELECT distinct KHR.ID
1059: FROM OKC_K_HEADERS_B KHR,
1060: OKL_STREAMS STM,
1061: OKL_STRM_TYPE_B STY,
1062: OKL_STRM_ELEMENTS SEL
1063: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)

Line 1074: /* FROM okc_k_headers_b */

1070: AND SEL.DATE_BILLED IS NULL;
1071:
1072:
1073: /* SELECT id */
1074: /* FROM okc_k_headers_b */
1075: /* WHERE contract_number = NVL(p_contract_number, contract_number)
1076: AND */
1077: /* sts_code = 'BOOKED' AND */
1078: /* id in ( */

Line 1080: /* FROM okc_k_headers_b orig, */

1076: AND */
1077: /* sts_code = 'BOOKED' AND */
1078: /* id in ( */
1079: /* SELECT rebook.id */
1080: /* FROM okc_k_headers_b orig, */
1081: /* okc_k_headers_b rebook */
1082: /* WHERE orig.contract_number = NVL(p_contract_number,
1083: orig.contract_number) and */
1084: /* orig.authoring_org_id =

Line 1081: /* okc_k_headers_b rebook */

1077: /* sts_code = 'BOOKED' AND */
1078: /* id in ( */
1079: /* SELECT rebook.id */
1080: /* FROM okc_k_headers_b orig, */
1081: /* okc_k_headers_b rebook */
1082: /* WHERE orig.contract_number = NVL(p_contract_number,
1083: orig.contract_number) and */
1084: /* orig.authoring_org_id =
1085: NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99) and */

Line 1090: /* FROM okc_k_headers_b mass_rebook, */

1086: /* rebook.orig_system_id1 = orig.id and */
1087: /* rebook.orig_system_source_code = 'OKL_REBOOK' */
1088: /* UNION */
1089: /* SELECT mass_rebook.id */
1090: /* FROM okc_k_headers_b mass_rebook, */
1091: /* okl_rbk_selected_contract rbk */
1092: /* WHERE mass_rebook.contract_number = NVL(p_contract_number,
1093: mass_rebook.contract_number) and */
1094: /* mass_rebook.authoring_org_id =

Line 1123: okc_k_headers_b khr,

1119: FROM
1120: okl_strm_elements ste,
1121: okl_streams stm,
1122: okl_strm_type_b sty,
1123: okc_k_headers_b khr,
1124: okl_k_headers khl,
1125: okc_k_lines_b kle,
1126: okc_statuses_b khs,
1127: okc_statuses_b kls

Line 1773: okc_k_headers_b khr,

1769: PS.class,
1770: PS.TERMS_SEQUENCE_NUMBER
1771: FROM
1772: okl_strm_type_b sty,
1773: okc_k_headers_b khr,
1774: okl_k_headers khl,
1775: okc_k_lines_b kle,
1776: okc_statuses_b khs,
1777: okc_statuses_b kls,

Line 1973: l_curr_code okc_k_headers_b.currency_code%TYPE;

1969:
1970:
1971: -- For currecy precision rounded amount
1972: l_ste_amount okl_strm_elements.amount%type;
1973: l_curr_code okc_k_headers_b.currency_code%TYPE;
1974: ------------------------------------------------------------
1975: -- For errors in Stream Elements Table
1976: ------------------------------------------------------------
1977:

Line 1998: contract_number okc_k_headers_b.contract_number%type,

1994: sel_id NUMBER,
1995: tld_id NUMBER,
1996: xsi_id NUMBER,
1997: bill_date DATE,
1998: contract_number okc_k_headers_b.contract_number%type,
1999: stream_name okl_strm_type_v.name%type,
2000: amount okl_strm_elements.amount%type,
2001: error_message Varchar2(2000)
2002: );