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.CSI_ORDER_FULFILL_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 2399: p_order_hdr_rec IN oe_order_headers_all%rowtype,

2395:
2396:
2397: PROCEDURE convert_wip_instance_to_cp(
2398: p_instance_id IN number,
2399: p_order_hdr_rec IN oe_order_headers_all%rowtype,
2400: p_order_line_rec IN oe_order_lines_all%rowtype,
2401: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2402: px_default_info_rec IN OUT nocopy default_info_rec,
2403: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 2412: l_order_header_rec oe_order_headers_all%rowtype;

2408: l_owner_party_id number;
2409: l_owner_account_id number;
2410:
2411: l_order_line_rec oe_order_lines_all%rowtype;
2412: l_order_header_rec oe_order_headers_all%rowtype;
2413:
2414: l_location_type_code varchar2(80);
2415: l_inst_object_ver_num number;
2416:

Line 4062: l_order_hdr_rec oe_order_headers_all%rowtype;

4058:
4059: l_c_ind binary_integer := 0;
4060: l_config_instances config_serial_inst_tbl;
4061:
4062: l_order_hdr_rec oe_order_headers_all%rowtype;
4063: l_order_line_rec oe_order_lines_all%rowtype;
4064: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4065:
4066: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 4175: FROM oe_order_headers_all

4171: FROM oe_order_lines_all
4172: WHERE line_id = p_config_rec.sub_model_line_id;
4173:
4174: SELECT * INTO l_order_hdr_rec
4175: FROM oe_order_headers_all
4176: WHERE header_id = l_order_line_rec.header_id;
4177:
4178: IF p_config_rec.serial_code in (2, 5) THEN
4179: FOR inst_rec IN in_rel_sc_inst_cur

Line 4480: p_order_hdr_rec IN oe_order_headers_all%rowtype,

4476: x_return_status := fnd_api.g_ret_sts_error;
4477: END stamp_om_line;
4478:
4479: PROCEDURE stamp_om_line_for_options(
4480: p_order_hdr_rec IN oe_order_headers_all%rowtype,
4481: p_order_line_rec IN oe_order_lines_all%rowtype,
4482: p_wip_instances IN wip_instances,
4483: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4484: px_default_info_rec IN OUT nocopy default_info_rec,

Line 6380: p_order_hdr_rec IN oe_order_headers_all%rowtype,

6376: /* to wip job link and converts them as customer products and build the */
6377: /* component of relationship with the parent (ato oc or the config item) */
6378:
6379: PROCEDURE process_ato_option_nsrl(
6380: p_order_hdr_rec IN oe_order_headers_all%rowtype,
6381: p_order_line_rec IN oe_order_lines_all%rowtype,
6382: p_config_rec IN config_rec,
6383: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6384: px_default_info_rec IN OUT nocopy default_info_rec,

Line 6760: p_order_hdr_rec IN oe_order_headers_all%rowtype,

6756: /* Identifies the wip issued instances that are tied in relation with the */
6757: /* serialized config and re-builds the relation with the OC if OC is IB */
6758: /* trackable. Assy Component Relations are build at the WIP completion event*/
6759: PROCEDURE process_ato_option_srl(
6760: p_order_hdr_rec IN oe_order_headers_all%rowtype,
6761: p_order_line_rec IN oe_order_lines_all%rowtype,
6762: p_config_rec IN config_rec,
6763: p_config_instances IN config_serial_inst_tbl,
6764: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

Line 7085: p_order_header_rec IN oe_order_headers_all%rowtype,

7081: END process_ato_option_srl;
7082:
7083: -- for ato options that are processed from wip
7084: PROCEDURE process_ato_option_from_wip(
7085: p_order_header_rec IN oe_order_headers_all%rowtype,
7086: p_order_line_rec IN oe_order_lines_all%rowtype,
7087: p_config_rec IN config_rec,
7088: p_config_instances IN config_serial_inst_tbl,
7089: px_default_info_rec IN OUT nocopy default_info_rec,

Line 7895: p_order_header_rec IN oe_order_headers_all%rowtype,

7891: debug(x_return_message);
7892: END cz_fulfillment;
7893:
7894: PROCEDURE query_tld_and_update_ib(
7895: p_order_header_rec IN oe_order_headers_all%rowtype,
7896: p_order_line_rec IN csi_order_ship_pub.order_line_rec, --fix for bug5589710
7897: px_default_info_rec IN OUT NOCOPY default_info_rec,
7898: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7899: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

Line 8214: l_order_header_rec oe_order_headers_all%rowtype;

8210: l_cascaded_flag varchar2(1) := 'N';
8211: l_shippable_item_flag varchar2(1) := 'N';
8212:
8213: l_order_line_rec oe_order_lines_all%rowtype;
8214: l_order_header_rec oe_order_headers_all%rowtype;
8215:
8216: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
8217: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8218:

Line 8337: FROM oe_order_headers_all

8333: WHERE line_id = p_order_line_id;
8334:
8335: SELECT *
8336: INTO l_order_header_rec
8337: FROM oe_order_headers_all
8338: WHERE header_id = l_order_line_rec.header_id;
8339:
8340: EXCEPTION
8341: WHEN no_data_found THEN

Line 9915: FROM oe_order_headers_all ooh,

9911: to_char(null) ib_install_loc,
9912: to_number(null) ib_install_loc_id,
9913: to_char(null) ib_current_loc,
9914: to_number(null) ib_current_loc_id
9915: FROM oe_order_headers_all ooh,
9916: oe_order_lines_all ool,
9917: mtl_system_items msi,
9918: mtl_unit_transactions mut,
9919: mtl_material_transactions mmt,

Line 9973: FROM oe_order_headers_all ooh,

9969: to_char(null) ib_install_loc,
9970: to_number(null) ib_install_loc_id,
9971: to_char(null) ib_current_loc,
9972: to_number(null) ib_current_loc_id
9973: FROM oe_order_headers_all ooh,
9974: oe_order_lines_all ool,
9975: mtl_system_items msi,
9976: mtl_unit_transactions mut,
9977: mtl_transaction_lot_numbers mtln,