APPS.GME_MAKE_TO_ORDER_PVT dependencies on OE_ORDER_LINES_ALL

Line 74: l_so_line_rec OE_ORDER_LINES_ALL%ROWTYPE;

70:
71: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
72: l_out_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
73: l_material_detail_rec GME_MATERIAL_DETAILS%ROWTYPE;
74: l_so_line_rec OE_ORDER_LINES_ALL%ROWTYPE;
75: l_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
76: l_so_batch_rsv_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
77: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
78: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;

Line 166: FROM oe_order_lines_all

162: AND m.organization_id = p_organization_id;
163:
164: CURSOR get_so_line_rec(p_so_line_id IN NUMBER) IS
165: SELECT *
166: FROM oe_order_lines_all
167: WHERE line_id = p_so_line_id;
168:
169: CURSOR get_batch_line(p_batch_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
170: SELECT *

Line 181: ,oe_order_lines_all ol

177: CURSOR Get_order_info(p_so_line_id IN NUMBER) IS
178: SELECT ol.line_number, mtl.segment1,
179: oh.order_number
180: FROM oe_order_headers_all oh
181: ,oe_order_lines_all ol
182: ,oe_transaction_types_all ot
183: ,mtl_system_items mtl
184: WHERE ol.line_id = p_so_line_id
185: and ol.header_id = oh.header_id

Line 1141: l_order_line_rec OE_ORDER_LINES_ALL%ROWTYPE;

1137: l_api_name CONSTANT VARCHAR2(30):= 'line_qualifies_for MTO';
1138: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1139: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
1140: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1141: l_order_line_rec OE_ORDER_LINES_ALL%ROWTYPE;
1142: l_item_type VARCHAR2(30);
1143:
1144: CURSOR get_order_line_rec(p_line_id IN NUMBER) IS
1145: SELECT *

Line 1146: FROM oe_order_lines_all

1142: l_item_type VARCHAR2(30);
1143:
1144: CURSOR get_order_line_rec(p_line_id IN NUMBER) IS
1145: SELECT *
1146: FROM oe_order_lines_all
1147: WHERE line_id = p_line_id;
1148:
1149: CURSOR cur_item(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
1150: SELECT item_type