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.OKC_CREATE_PO_FROM_K_PVT dependencies on OKC_RULES_B

Line 155: ,object1_id1 okc_rules_b.object1_id1%TYPE

151: TYPE rule_rec_typ IS RECORD
152: (
153: chr_id okc_k_headers_b.id%TYPE
154: ,cle_id okc_k_lines_b.id%TYPE
155: ,object1_id1 okc_rules_b.object1_id1%TYPE
156: ,object1_id2 okc_rules_b.object1_id2%TYPE
157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
158: ,object2_id1 okc_rules_b.object2_id1%TYPE
159: ,object2_id2 okc_rules_b.object2_id2%TYPE

Line 156: ,object1_id2 okc_rules_b.object1_id2%TYPE

152: (
153: chr_id okc_k_headers_b.id%TYPE
154: ,cle_id okc_k_lines_b.id%TYPE
155: ,object1_id1 okc_rules_b.object1_id1%TYPE
156: ,object1_id2 okc_rules_b.object1_id2%TYPE
157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
158: ,object2_id1 okc_rules_b.object2_id1%TYPE
159: ,object2_id2 okc_rules_b.object2_id2%TYPE
160: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE

Line 157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE

153: chr_id okc_k_headers_b.id%TYPE
154: ,cle_id okc_k_lines_b.id%TYPE
155: ,object1_id1 okc_rules_b.object1_id1%TYPE
156: ,object1_id2 okc_rules_b.object1_id2%TYPE
157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
158: ,object2_id1 okc_rules_b.object2_id1%TYPE
159: ,object2_id2 okc_rules_b.object2_id2%TYPE
160: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
161: ,rule_information_category okc_rules_b.rule_information_category%TYPE

Line 158: ,object2_id1 okc_rules_b.object2_id1%TYPE

154: ,cle_id okc_k_lines_b.id%TYPE
155: ,object1_id1 okc_rules_b.object1_id1%TYPE
156: ,object1_id2 okc_rules_b.object1_id2%TYPE
157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
158: ,object2_id1 okc_rules_b.object2_id1%TYPE
159: ,object2_id2 okc_rules_b.object2_id2%TYPE
160: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
161: ,rule_information_category okc_rules_b.rule_information_category%TYPE
162: ,rule_information1 okc_rules_b.rule_information1%TYPE

Line 159: ,object2_id2 okc_rules_b.object2_id2%TYPE

155: ,object1_id1 okc_rules_b.object1_id1%TYPE
156: ,object1_id2 okc_rules_b.object1_id2%TYPE
157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
158: ,object2_id1 okc_rules_b.object2_id1%TYPE
159: ,object2_id2 okc_rules_b.object2_id2%TYPE
160: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
161: ,rule_information_category okc_rules_b.rule_information_category%TYPE
162: ,rule_information1 okc_rules_b.rule_information1%TYPE
163: );

Line 160: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE

156: ,object1_id2 okc_rules_b.object1_id2%TYPE
157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
158: ,object2_id1 okc_rules_b.object2_id1%TYPE
159: ,object2_id2 okc_rules_b.object2_id2%TYPE
160: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
161: ,rule_information_category okc_rules_b.rule_information_category%TYPE
162: ,rule_information1 okc_rules_b.rule_information1%TYPE
163: );
164:

Line 161: ,rule_information_category okc_rules_b.rule_information_category%TYPE

157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
158: ,object2_id1 okc_rules_b.object2_id1%TYPE
159: ,object2_id2 okc_rules_b.object2_id2%TYPE
160: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
161: ,rule_information_category okc_rules_b.rule_information_category%TYPE
162: ,rule_information1 okc_rules_b.rule_information1%TYPE
163: );
164:
165: -------------------------------------------------------------------------

Line 162: ,rule_information1 okc_rules_b.rule_information1%TYPE

158: ,object2_id1 okc_rules_b.object2_id1%TYPE
159: ,object2_id2 okc_rules_b.object2_id2%TYPE
160: ,jtot_object2_code okc_rules_b.jtot_object2_code%TYPE
161: ,rule_information_category okc_rules_b.rule_information_category%TYPE
162: ,rule_information1 okc_rules_b.rule_information1%TYPE
163: );
164:
165: -------------------------------------------------------------------------
166: -- po_header_rec_type holds the values that will be inserted in

Line 189: ship_to_location_id okc_rules_b.object1_id1%type,

185: agent_id okx_buyers_v.id1%type,
186: vendor_id okx_vendors_v.id1%type,
187: vendor_site_id okx_vendor_sites_v.id1%type,
188: vendor_contact_id okc_contacts.object1_id1%type,
189: ship_to_location_id okc_rules_b.object1_id1%type,
190: bill_to_location_id okc_rules_b.object1_id1%type,
191: terms_id okc_rules_b.object1_id1%type,
192: freight_terms okc_rules_b.object1_id1%type,
193: approved_date okc_k_headers_b.date_signed%type,

Line 190: bill_to_location_id okc_rules_b.object1_id1%type,

186: vendor_id okx_vendors_v.id1%type,
187: vendor_site_id okx_vendor_sites_v.id1%type,
188: vendor_contact_id okc_contacts.object1_id1%type,
189: ship_to_location_id okc_rules_b.object1_id1%type,
190: bill_to_location_id okc_rules_b.object1_id1%type,
191: terms_id okc_rules_b.object1_id1%type,
192: freight_terms okc_rules_b.object1_id1%type,
193: approved_date okc_k_headers_b.date_signed%type,
194: ship_to_organization_id okc_rules_b.object2_id1%type,

Line 191: terms_id okc_rules_b.object1_id1%type,

187: vendor_site_id okx_vendor_sites_v.id1%type,
188: vendor_contact_id okc_contacts.object1_id1%type,
189: ship_to_location_id okc_rules_b.object1_id1%type,
190: bill_to_location_id okc_rules_b.object1_id1%type,
191: terms_id okc_rules_b.object1_id1%type,
192: freight_terms okc_rules_b.object1_id1%type,
193: approved_date okc_k_headers_b.date_signed%type,
194: ship_to_organization_id okc_rules_b.object2_id1%type,
195: comments varchar2(100) -- used to form the comments

Line 192: freight_terms okc_rules_b.object1_id1%type,

188: vendor_contact_id okc_contacts.object1_id1%type,
189: ship_to_location_id okc_rules_b.object1_id1%type,
190: bill_to_location_id okc_rules_b.object1_id1%type,
191: terms_id okc_rules_b.object1_id1%type,
192: freight_terms okc_rules_b.object1_id1%type,
193: approved_date okc_k_headers_b.date_signed%type,
194: ship_to_organization_id okc_rules_b.object2_id1%type,
195: comments varchar2(100) -- used to form the comments
196: -- with the contract number

Line 194: ship_to_organization_id okc_rules_b.object2_id1%type,

190: bill_to_location_id okc_rules_b.object1_id1%type,
191: terms_id okc_rules_b.object1_id1%type,
192: freight_terms okc_rules_b.object1_id1%type,
193: approved_date okc_k_headers_b.date_signed%type,
194: ship_to_organization_id okc_rules_b.object2_id1%type,
195: comments varchar2(100) -- used to form the comments
196: -- with the contract number
197: );
198:

Line 221: ship_to_organization_id okc_rules_b.object1_id1%type,

217: need_by_date okc_k_lines_b.start_date%type,
218: interface_line_id po_lines_interface.interface_line_id%type,
219: po_line_id po_lines_interface.po_line_id%type,
220: interface_header_id po_headers_interface.interface_header_id%type,
221: ship_to_organization_id okc_rules_b.object1_id1%type,
222: ship_to_location_id okc_rules_b.object1_id1%type,
223: terms_id okc_rules_b.object1_id1%type,
224: freight_terms okc_rules_b.object1_id1%type
225: );

Line 222: ship_to_location_id okc_rules_b.object1_id1%type,

218: interface_line_id po_lines_interface.interface_line_id%type,
219: po_line_id po_lines_interface.po_line_id%type,
220: interface_header_id po_headers_interface.interface_header_id%type,
221: ship_to_organization_id okc_rules_b.object1_id1%type,
222: ship_to_location_id okc_rules_b.object1_id1%type,
223: terms_id okc_rules_b.object1_id1%type,
224: freight_terms okc_rules_b.object1_id1%type
225: );
226:

Line 223: terms_id okc_rules_b.object1_id1%type,

219: po_line_id po_lines_interface.po_line_id%type,
220: interface_header_id po_headers_interface.interface_header_id%type,
221: ship_to_organization_id okc_rules_b.object1_id1%type,
222: ship_to_location_id okc_rules_b.object1_id1%type,
223: terms_id okc_rules_b.object1_id1%type,
224: freight_terms okc_rules_b.object1_id1%type
225: );
226:
227: -------------------------------------------------------------------------

Line 224: freight_terms okc_rules_b.object1_id1%type

220: interface_header_id po_headers_interface.interface_header_id%type,
221: ship_to_organization_id okc_rules_b.object1_id1%type,
222: ship_to_location_id okc_rules_b.object1_id1%type,
223: terms_id okc_rules_b.object1_id1%type,
224: freight_terms okc_rules_b.object1_id1%type
225: );
226:
227: -------------------------------------------------------------------------
228: -- po_distributions_rec_type holds the values that will be inserted in

Line 671: ,okc_rules_b rul

667: ,rul.jtot_object2_code
668: ,rul.rule_information_category
669: ,rul.rule_information1
670: FROM okc_rule_groups_b rgp
671: ,okc_rules_b rul
672: WHERE
673: rgp.dnz_chr_id = b_chr_id
674: AND rul.rgp_id = rgp.id
675: AND ((rgp.cle_id IS NULL AND b_cle_id IS NULL) OR