APPS.GME_MAKE_TO_ORDER_PVT dependencies on OE_ORDER_LINES_ALL

Line 64: l_so_line_rec OE_ORDER_LINES_ALL%ROWTYPE;

60:
61: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
62: l_out_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
63: l_material_detail_rec GME_MATERIAL_DETAILS%ROWTYPE;
64: l_so_line_rec OE_ORDER_LINES_ALL%ROWTYPE;
65: l_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
66: l_so_batch_rsv_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
67: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
68: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;

Line 151: FROM oe_order_lines_all

147: AND m.organization_id = p_organization_id;
148:
149: CURSOR get_so_line_rec(p_so_line_id IN NUMBER) IS
150: SELECT *
151: FROM oe_order_lines_all
152: WHERE line_id = p_so_line_id;
153:
154: CURSOR get_batch_line(p_batch_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
155: SELECT *

Line 166: ,oe_order_lines_all ol

162: CURSOR Get_order_info(p_so_line_id IN NUMBER) IS
163: SELECT ol.line_number, mtl.segment1,
164: oh.order_number
165: FROM oe_order_headers_all oh
166: ,oe_order_lines_all ol
167: ,oe_transaction_types_all ot
168: ,mtl_system_items mtl
169: WHERE ol.line_id = p_so_line_id
170: and ol.header_id = oh.header_id

Line 1037: l_order_line_rec OE_ORDER_LINES_ALL%ROWTYPE;

1033: l_api_name CONSTANT VARCHAR2(30):= 'line_qualifies_for MTO';
1034: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1035: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
1036: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1037: l_order_line_rec OE_ORDER_LINES_ALL%ROWTYPE;
1038: l_item_type VARCHAR2(30);
1039:
1040: CURSOR get_order_line_rec(p_line_id IN NUMBER) IS
1041: SELECT *

Line 1042: FROM oe_order_lines_all

1038: l_item_type VARCHAR2(30);
1039:
1040: CURSOR get_order_line_rec(p_line_id IN NUMBER) IS
1041: SELECT *
1042: FROM oe_order_lines_all
1043: WHERE line_id = p_line_id;
1044:
1045: CURSOR cur_item(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
1046: SELECT item_type