DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on MTL_PARAMETERS

Line 1395: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;

1391: l_is_lot_control BOOLEAN := FALSE;
1392: l_is_serial_control BOOLEAN := FALSE;
1393: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
1394: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
1395: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
1396:
1397: l_api_version_number CONSTANT NUMBER := 1.0;
1398: l_api_name CONSTANT VARCHAR2(30) := 'Check_Looose_Quantity';
1399: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1415: FROM mtl_parameters

1411: l_cgcnt NUMBER;
1412:
1413: CURSOR c_org IS
1414: SELECT negative_inv_receipt_code
1415: FROM mtl_parameters
1416: WHERE organization_id = p_organization_id;
1417:
1418: CURSOR c_lot_exp IS
1419: SELECT expiration_date

Line 4100: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;

4096: l_is_serial_control BOOLEAN := FALSE;
4097:
4098: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
4099: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
4100: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
4101:
4102: l_api_version_number CONSTANT NUMBER := 1.0;
4103: l_api_name CONSTANT VARCHAR2(30) := 'Check_Looose_and_packed_Qty';
4104: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 4119: FROM mtl_parameters

4115: l_suggested_loc_id NUMBER;
4116:
4117: CURSOR c_org IS
4118: SELECT negative_inv_receipt_code
4119: FROM mtl_parameters
4120: WHERE organization_id = p_organization_id;
4121:
4122: CURSOR c_lot_exp IS
4123: SELECT expiration_date