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 2439: p_order_hdr_rec IN oe_order_headers_all%rowtype,

2435:
2436:
2437: PROCEDURE convert_wip_instance_to_cp(
2438: p_instance_id IN number,
2439: p_order_hdr_rec IN oe_order_headers_all%rowtype,
2440: p_order_line_rec IN oe_order_lines_all%rowtype,
2441: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2442: px_default_info_rec IN OUT nocopy default_info_rec,
2443: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 2452: l_order_header_rec oe_order_headers_all%rowtype;

2448: l_owner_party_id number;
2449: l_owner_account_id number;
2450:
2451: l_order_line_rec oe_order_lines_all%rowtype;
2452: l_order_header_rec oe_order_headers_all%rowtype;
2453:
2454: l_location_type_code varchar2(80);
2455: l_inst_object_ver_num number;
2456:

Line 4110: l_order_hdr_rec oe_order_headers_all%rowtype;

4106:
4107: l_c_ind binary_integer := 0;
4108: l_config_instances config_serial_inst_tbl;
4109:
4110: l_order_hdr_rec oe_order_headers_all%rowtype;
4111: l_order_line_rec oe_order_lines_all%rowtype;
4112: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4113:
4114: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 4223: FROM oe_order_headers_all

4219: FROM oe_order_lines_all
4220: WHERE line_id = p_config_rec.sub_model_line_id;
4221:
4222: SELECT * INTO l_order_hdr_rec
4223: FROM oe_order_headers_all
4224: WHERE header_id = l_order_line_rec.header_id;
4225:
4226: IF p_config_rec.serial_code in (2, 5) THEN
4227: FOR inst_rec IN in_rel_sc_inst_cur

Line 4528: p_order_hdr_rec IN oe_order_headers_all%rowtype,

4524: x_return_status := fnd_api.g_ret_sts_error;
4525: END stamp_om_line;
4526:
4527: PROCEDURE stamp_om_line_for_options(
4528: p_order_hdr_rec IN oe_order_headers_all%rowtype,
4529: p_order_line_rec IN oe_order_lines_all%rowtype,
4530: p_wip_instances IN wip_instances,
4531: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4532: px_default_info_rec IN OUT nocopy default_info_rec,

Line 7150: p_order_hdr_rec IN oe_order_headers_all%rowtype,

7146: /* to wip job link and converts them as customer products and build the */
7147: /* component of relationship with the parent (ato oc or the config item) */
7148:
7149: PROCEDURE process_ato_option_nsrl(
7150: p_order_hdr_rec IN oe_order_headers_all%rowtype,
7151: p_order_line_rec IN oe_order_lines_all%rowtype,
7152: p_config_rec IN config_rec,
7153: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7154: px_default_info_rec IN OUT nocopy default_info_rec,

Line 7530: p_order_hdr_rec IN oe_order_headers_all%rowtype,

7526: /* Identifies the wip issued instances that are tied in relation with the */
7527: /* serialized config and re-builds the relation with the OC if OC is IB */
7528: /* trackable. Assy Component Relations are build at the WIP completion event*/
7529: PROCEDURE process_ato_option_srl(
7530: p_order_hdr_rec IN oe_order_headers_all%rowtype,
7531: p_order_line_rec IN oe_order_lines_all%rowtype,
7532: p_config_rec IN config_rec,
7533: p_config_instances IN config_serial_inst_tbl,
7534: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

Line 7876: p_order_header_rec IN oe_order_headers_all%rowtype,

7872: END process_ato_option_srl;
7873:
7874: -- for ato options that are processed from wip
7875: PROCEDURE process_ato_option_from_wip(
7876: p_order_header_rec IN oe_order_headers_all%rowtype,
7877: p_order_line_rec IN oe_order_lines_all%rowtype,
7878: p_config_rec IN config_rec,
7879: p_config_instances IN config_serial_inst_tbl,
7880: px_default_info_rec IN OUT nocopy default_info_rec,

Line 8692: p_order_header_rec IN oe_order_headers_all%rowtype,

8688: debug(x_return_message);
8689: END cz_fulfillment;
8690:
8691: PROCEDURE query_tld_and_update_ib(
8692: p_order_header_rec IN oe_order_headers_all%rowtype,
8693: p_order_line_rec IN csi_order_ship_pub.order_line_rec, --fix for bug5589710
8694: px_default_info_rec IN OUT NOCOPY default_info_rec,
8695: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
8696: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

Line 9114: l_order_header_rec oe_order_headers_all%rowtype;

9110: l_cascaded_flag varchar2(1) := 'N';
9111: l_shippable_item_flag varchar2(1) := 'N';
9112:
9113: l_order_line_rec oe_order_lines_all%rowtype;
9114: l_order_header_rec oe_order_headers_all%rowtype;
9115:
9116: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
9117: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
9118:

Line 9258: FROM oe_order_headers_all

9254: WHERE line_id = p_order_line_id;
9255:
9256: SELECT *
9257: INTO l_order_header_rec
9258: FROM oe_order_headers_all
9259: WHERE header_id = l_order_line_rec.header_id;
9260:
9261: EXCEPTION
9262: WHEN no_data_found THEN

Line 10931: FROM oe_order_headers_all ooh,

10927: to_char(null) ib_install_loc,
10928: to_number(null) ib_install_loc_id,
10929: to_char(null) ib_current_loc,
10930: to_number(null) ib_current_loc_id
10931: FROM oe_order_headers_all ooh,
10932: oe_order_lines_all ool,
10933: mtl_system_items msi,
10934: mtl_unit_transactions mut,
10935: mtl_material_transactions mmt,

Line 10989: FROM oe_order_headers_all ooh,

10985: to_char(null) ib_install_loc,
10986: to_number(null) ib_install_loc_id,
10987: to_char(null) ib_current_loc,
10988: to_number(null) ib_current_loc_id
10989: FROM oe_order_headers_all ooh,
10990: oe_order_lines_all ool,
10991: mtl_system_items msi,
10992: mtl_unit_transactions mut,
10993: mtl_transaction_lot_numbers mtln,