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.GME_MAKE_TO_ORDER_PVT dependencies on GME_MTO_RULE_ASSIGNMENTS

Line 85: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;

81: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
82: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
83: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
84: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;
85: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
86: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
87: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
88:
89: l_item_id NUMBER;

Line 87: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;

83: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
84: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;
85: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
86: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
87: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
88:
89: l_item_id NUMBER;
90: l_primary_uom_code VARCHAR2(3);
91: l_total_primary_rsv_qty NUMBER;

Line 1138: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;

1134: l_msg_count NUMBER;
1135: l_msg_data VARCHAR2 ( 240 );
1136: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
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);

Line 1140: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;

1136: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
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

Line 1219: p_mto_assignments_rec IN GME_MTO_RULE_ASSIGNMENTS%ROWTYPE

1215: END line_qualifies_for_MTO;
1216:
1217: PROCEDURE retrieve_rule
1218: (
1219: p_mto_assignments_rec IN GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
1220: , x_mto_rules_rec OUT NOCOPY GME_MTO_RULES%ROWTYPE
1221: , x_mto_assignments_rec OUT NOCOPY GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
1222: , x_return_status OUT NOCOPY VARCHAR2
1223: , x_msg_count OUT NOCOPY NUMBER

Line 1221: , x_mto_assignments_rec OUT NOCOPY GME_MTO_RULE_ASSIGNMENTS%ROWTYPE

1217: PROCEDURE retrieve_rule
1218: (
1219: p_mto_assignments_rec IN GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
1220: , x_mto_rules_rec OUT NOCOPY GME_MTO_RULES%ROWTYPE
1221: , x_mto_assignments_rec OUT NOCOPY GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
1222: , x_return_status OUT NOCOPY VARCHAR2
1223: , x_msg_count OUT NOCOPY NUMBER
1224: , x_msg_data OUT NOCOPY VARCHAR2
1225: ) IS

Line 1228: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;

1224: , x_msg_data OUT NOCOPY VARCHAR2
1225: ) IS
1226:
1227: l_api_name CONSTANT VARCHAR2(30):= 'retrieve_rule';
1228: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
1229: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
1230:
1231: Cursor get_assignment IS
1232: Select decode(site_use_id, null, 0, site_use_id) site_use_id

Line 1239: From gme_mto_rule_assignments

1235: , decode(item_type, null, ' ', item_type) item_type
1236: , rule_assign_id
1237: , rule_id
1238: , organization_id
1239: From gme_mto_rule_assignments
1240: Where organization_id = p_mto_assignments_rec.organization_id
1241: and (inventory_item_id = p_mto_assignments_rec.inventory_item_id
1242: or inventory_item_id is null )
1243: and (item_type = p_mto_assignments_rec.item_type